Failing over to standby - taking a long time
edited May 5, 2016 5:04AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi
We have a 2 node RAC 11.2.0.3 database with a single stand alone database
The primary RAC database had a media failure from which it cannot be recovered / restore
Now we are trying to perform a fail over so that we can use the standby database
Data loss is not a problem as we know it is BEHIND the primary database
SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
2 9554 9601
SELECT 'Last Applied : ' Logs,
TO_CHAR(next_time,'DD-MON-YY:HH24:MI:SS') TIME,thread#,sequence#
FROM gv$archived_log where thread#=1 and sequence# =
0