使用旧的控制文件恢复

在做resetlogs启数据库也会因为数据文件内部一致而中止,需要恢复

备份控制文件

alter database backup controlfileto '/bk/ctl.bk';

SQL> alter system switch logfile;

alter system switch logfile

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

Oracle instance started.

Total System Global Area 314572800 bytes

Fixed Size 1219136 bytes

Variable Size 100664768 bytes

Database Buffers 205520896 bytes

Redo Buffers 7168000 bytes

ORA-00205: error in identifying control file, checkalert log for more info

SQL> ! /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl

/bin/bash: /bk/ctl.bk: ????

SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl

SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control03.ctl

SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control01.ctl

SQL> alter database mount;

Database altered.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option fordatabase open