How to Perform Failover When GAP on Standby
timscnNov 17 2012 — edited Nov 17 2012hi ,
i want to activate my standby in read/write
but i can't..i don't have archivelogs and i can't restore standby from incremental backup
ALTER DATABASE ACTIVATE STANDBY DATABASE
ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (work)
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Signalling error 1152 for datafile 1!
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Waiting for thread 1 sequence 1174115
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:07:09 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:07:19 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:07:29 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:07:39 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:07:50 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Sat Nov 17 17:08:00 2012
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Standby crash recovery need archive log for thread 1 sequence 1174115 to continue.
Please verify that primary database is transporting redo logs to the standby database.
Wait timeout: thread 1 sequence 1174115
Standby crash recovery aborted due to error 16016.
Errors in file /oracle/diag/rdbms/b2resnew/work/trace/work_ora_36176058.trc:
ORA-16016: archived log for thread 1 sequence# 1174115 unavailable
Recovery interrupted!
Completed standby crash recovery.
Signalling error 1152 for datafile 1!
ORA-1152 signalled during: ALTER DATABASE ACTIVATE STANDBY DATABASE...
Sat Nov 17 17:08:12 2012
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
Attempt to do a Terminal Recovery (work)
Media Recovery Start: Managed Standby Recovery (work)
started logmerger process
Sat Nov 17 17:08:12 2012
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 32 slaves
Media Recovery Waiting for thread 1 sequence 1174115
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
Fetching gap sequence in thread 1, gap sequence 1174115-1174214
RECOVER...FINISH not allowed due to gap
GAP - thread 1 sequence 1174115-1174214
DBID 3179924020 branch 606674959
Recovery interrupted!
Media Recovery failed with error 16171
Errors in file /oracle/diag/rdbms/b2resnew/work/trace/work_pr00_37421192.trc:
ORA-00283: recovery session canceled due to errors
ORA-16171: RECOVER...FINISH not allowed due to gap for thr 1, seq 1174115-1174214
Slave exiting with ORA-283 exception
Errors in file /oracle/diag/rdbms/b2resnew/work/trace/work_pr00_37421192.trc:
ORA-00283: recovery session canceled due to errors
ORA-16171: RECOVER...FINISH not allowed due to gap for thr 1, seq 1174115-1174214
ORA-10877 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH ...
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
ALTER DATABASE ACTIVATE STANDBY DATABASE
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradata/ctrl/system01.dbf'
SQL> RECOVER MANAGED STANDBY DATABASE FINISH
ORA-10877: error signaled in parallel recovery slave
SQL>
how open my physical standby in rw?
thanks