模拟控制文件丢失-数据文件和日志文件都是最新，但备份是上一次resetlogs之前...

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@localhost NACEC]$ rm -rf *.ctl

SQL> startup;

ORACLE instance started.

Total System Global Area  419430400 bytes

Fixed Size                  1267836 bytes

Variable Size             356517764 bytes

Database Buffers           58720256 bytes

Redo Buffers                2924544 bytes

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

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  419430400 bytes

Fixed Size                  1267836 bytes

Variable Size             356517764 bytes

Database Buffers           58720256 bytes

Redo Buffers                2924544 bytes

[oracle@localhost wqbf]$ cp *.ctl /dat/DBData/oradata/NACEC/

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  419430400 bytes

Fixed Size                  1267836 bytes

Variable Size             356517764 bytes

Database Buffers           58720256 bytes

Redo Buffers                2924544 bytes

Database mounted.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: '/dat/DBData/oradata/NACEC/system01.dbf'

无论采用什么方法，都打不开DB，因为我之前已经resetlogs数据库了，所以之前的控制文件备份不好用

如果没有resetlogs过数据库，采用alter database using backup controlfile(until cancel)即可恢复

只能采用其他的方法了

[oracle@localhost dbs]$ vi initNACEC.ora

在初始化参数文件里面添加_allow_resetlogs_corruption=true

SQL> startup pfile='/dat/DBSoftware/oracle/product/10.2.0/db_1/dbs/initNACEC.ora';

ORACLE instance started.

Total System Global Area  419430400 bytes

Fixed Size                  1267836 bytes

Variable Size             356517764 bytes

Database Buffers           58720256 bytes

Redo Buffers                2924544 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31448824/viewspace-2137536/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31448824/viewspace-2137536/