ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl_1/system01.dbf'
1.select SWITCHOVER#, DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
SWITCHOVER# DATABASE_ROLE SWITCHOVER_STATUS
----------- ---------------- --------------------
0 PHYSICAL STANDBY RECOVERY NEEDED
2.alter database backup controlfile to trace as '/u01/aa';
重建控制文件
sqlplus / as sysdba
.startup nomount pfile='/home/oracle/1.ora';
从aa文件中提取
CREATE CONTROLFILE REUSE DATABASE "WWG" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_1/redo01.log' SIZE 50M,
GROUP 2 '/u01/app/oracle/oradata/orcl_1/redo02.log' SIZE 50M,
GROUP 3 '/u01/app/oracle/oradata/orcl_1/redo03.log' SIZE 50M
-- STANDBY LOGFILE
-- GROUP 10 '/u01/app/oracle/oradata/orcl_1/redo10.log' SIZE 50M
DATAFILE
'/u01/app/oracle/oradata/orcl_1/system01.dbf',
'/u01/app/oracle/oradata/orcl_1/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_1/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_1/user01.dbf',
'/u01/app/oracle/oradata/orcl_1/undotbs02.dbf'
CHARACTER SET ZHS16GBK;
3.alter database open resetlogs;
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
4.alter database disable thread 2;
*
ERROR at line 1:
ORA-01109: database not open
5.SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile
ORA-00279: change 2256923 generated at 11/08/2013 01:35:51 needed for thread 2
ORA-00289: suggestion :
/u01/app/oracle/product/10.2.0/db_1/dbs/arch2_109_829828329.dbf
ORA-00280: change 2256923 for thread 2 is in sequence #109
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl_1/system01.dbf'
6.select * from v$log;
alter database clear logfile group 1;(1,2,3)
7.alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
7.SQL> show parameter clu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string
8. 编辑initsid.ora
_allow_error_simulation= TRUE
跳过检查点。
_allow_resetlogs_corruption= TRUE
_no_recovery_through_resetlogs=TRUE