物理dg failover 后 system01.dbf 不一致

ORA-16004: backup database requires recovery
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