WAKE-UP DATAGUARD KICK IN THE FACE

 #####################################

# WAKE-UP DATAGUARD KICK IN THE FACE

#####################################

# sqlplus

alter database recover managed standby database cancel;

alter database recover managed standby database disconnect nodelay;

# dgmgrl /

edit database <db_unique_name> set state='TRANSPORT-OFF';

edit database <db_unique_name> set state='TRANSPORT-ON';

set linesize 2000 colsep | pagesize 2000

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"

FROM

(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,

(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL

WHERE

ARCH.THREAD# = APPL.THREAD#;

select 'applied logs' from dual;

select thread#, sequence#, first_time from v$archived_log where (thread#, sequence#) in (select thread#, max(sequence#) from v$archived_log where applied='YES' group by thread#) order by thread#;

select 'shipped logs' from dual;

select thread#, sequence#, first_time from v$archived_log where (thread#, sequence#) in (select thread#, max(sequence#) 

from v$archived_log group by thread#) order by thread#;