shutdown immediate;
c
delete file '/usr2/ora817/oradata/ora817/control03.ctl'
cp '/usr2/ora817/oradata/ora817/control02.ctl'
to '/usr2/ora817/oradata/ora817/control03.ctl'
startup;
c
delete file '/usr2/ora817/oradata/ora817/control03.ctl'
cp '/usr2/ora817/oradata/ora817/control02.ctl'
to '/usr2/ora817/oradata/ora817/control03.ctl'
startup;
shutdown immediate
startup mount
recover database
學習
在nomount重新创建控制文件
如果你以前有控制文件的文本备份就好了
如alter database backup conctrolfile to trace;
备份出来的文件
-------------------------------------
你损坏的可能还不止控制文件,但一步一步来了。
good lucky
SQL> startup
ORACLE instance started.Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
重建控制文件
SQL> CREATE CONTROLFILE REUSE DATABASE "TEST1" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 1
6 MAXLOGHISTORY 226
7 LOGFILE
8 GROUP 1 'E:\ORACLE\ORA92\TEST\REDO01.LOG' SIZE 30M,
9 GROUP 2 'E:\ORACLE\ORA92\TEST\REDO02.LOG' SIZE 30M,
10 GROUP 3 'E:\ORACLE\ORA92\TEST\REDO03.LOG' SIZE 30M
11 DATAFILE
12 'E:\ORACLE\ORA92\TEST\SYSTEM01.DBF',
13 'E:\ORACLE\ORA92\TEST\UNDOTBS01.DBF',
14 'E:\ORACLE\ORA92\TEST\DRSYS01.DBF',
15 'E:\ORACLE\ORA92\TEST\INDX01.DBF',
16 'E:\ORACLE\ORA92\TEST\TOOLS01.DBF',
17 'E:\ORACLE\ORA92\TEST\USERS01.DBF',
18 'E:\ORACLE\ORA92\TEST\XDB01.DBF',
19 'E:\ORACLE\ORA92\TEST\RMAN01.DBF'
20 CHARACTER SET ZHS16GBK
21 ;Control file created.完全恢复数据库
SQL> recover database;
Media recovery complete.打开数据库
SQL> alter database open;Database altered.
在非归档情况下:
SQL> startup
ORACLE instance started.Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: 'E:\ORACLE\ORA92\TEST\CONTROL02.CTL'SQL> CREATE CONTROLFILE REUSE DATABASE "TEST1" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 1
6 MAXLOGHISTORY 226
7 LOGFILE
8 GROUP 1 'E:\ORACLE\ORA92\TEST\REDO01.LOG' SIZE 30M,
9 GROUP 2 'E:\ORACLE\ORA92\TEST\REDO02.LOG' SIZE 30M,
10 GROUP 3 'E:\ORACLE\ORA92\TEST\REDO03.LOG' SIZE 30M
11 DATAFILE
12 'E:\ORACLE\ORA92\TEST\SYSTEM01.DBF',
13 'E:\ORACLE\ORA92\TEST\UNDOTBS01.DBF',
14 'E:\ORACLE\ORA92\TEST\DRSYS01.DBF',
15 'E:\ORACLE\ORA92\TEST\INDX01.DBF',
16 'E:\ORACLE\ORA92\TEST\TOOLS01.DBF',
17 'E:\ORACLE\ORA92\TEST\USERS01.DBF',
18 'E:\ORACLE\ORA92\TEST\XDB01.DBF',
19 'E:\ORACLE\ORA92\TEST\RMAN01.DBF'
20 CHARACTER SET ZHS16GBK
21 ;Control file created.完全恢复数据库
SQL> recover database;
Media recovery complete.
2. 如果有控制文件的备份,将出错的文件删除,把备份文件COPY上去,并将文件名改成相同的。