ORA-00206 error in writing control file name block num, blocks num Cause: A disk write-failure occurred while attempting to write to the specified control file. The block location of the failure is given. Action: Check that the disk is online. If it is not, bring it online and shut down and restart Oracle. If the disk is online, then look for operating system reasons for Oracle's inability to write to the disk or control file. See the Oracle7 Server Administrator's Guide for information on recovering from the loss of a control file.See also your operating system-specific Oracle documentation.
See the Oracle7 Server Administrator's Guide for information on recovering from the loss of a control file如何重新恢复呀??
oracle版本,操作系统告诉我们
示例: STARTUP NOMOUNT CREATE CONTROLFILE set DATABASE "tst" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 1 MAXLOGHISTORY 1134 LOGFILE GROUP 1 ( '/user1/tst11idb/log01a.dbf', '/user1/tst11idb/log01b.dbf' ) SIZE 10M, GROUP 2 ( '/user1/tst11idb/log02a.dbf', '/user1/tst11idb/log02b.dbf' ) SIZE 10M DATAFILE '/user1/tst11idb/system01.dbf', . . . . '/user1/tst11idb/applsysx03.dbf' CHARACTER SET ZHS16CGB231280 ; ALTER DATABASE OPEN RESETLOGS; ALTER TABLESPACE TEMP ADD TEMPFILE '/user1/tst11idb/temp01.dbf' REUSE;
已连接。
SQL> stratup force
SP2-0734: 未知的命令开头 "stratup fo..." - 忽略了剩余的行。
SQL> startup force
ORACLE 例程已经启动。Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
ORA-00221: ????????
ORA-00206: ???????? (? 1?# ? 1)
ORA-00202: ????: 'C:\ORA8\ORADATA\ORA8\CONTROL01.CTL'
ORA-27072: skgfdisp: I/O ??
OSD-04008: WriteFile() J'0\,N^7(P4HkND<~
O/S-Error: (OS 5) >\>x7CNJ!#好像不行哟!
specified control file. The block location of the failure is given. Action: Check that the disk is online. If it is not, bring it online and
shut down and restart Oracle. If the disk is online, then look for
operating system reasons for Oracle's inability to write to the disk
or control file. See the Oracle7 Server Administrator's Guide for
information on recovering from the loss of a control file.See also your
operating system-specific Oracle documentation.
information on recovering from the loss of a control file如何重新恢复呀??
STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "tst" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 1134
LOGFILE
GROUP 1 (
'/user1/tst11idb/log01a.dbf',
'/user1/tst11idb/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/user1/tst11idb/log02a.dbf',
'/user1/tst11idb/log02b.dbf'
) SIZE 10M
DATAFILE
'/user1/tst11idb/system01.dbf',
.
.
.
.
'/user1/tst11idb/applsysx03.dbf'
CHARACTER SET ZHS16CGB231280
;
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/user1/tst11idb/temp01.dbf' REUSE;