Oracle datagaurd – applied

https://oracle-artifacts.blogspot.com/2012/04/oracle-data-guard-issues-applied-column.html

SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP; 

 THREAD#          LOW_SEQUENCE  HIGH_SEQUENCE#

———————————————-

1          65524      65533

SQL> SELECT max(sequence#) AS “STANDBY“, applied FROM v$archived_log GROUP BY applied;

1. Used Simple SCP to transfer the missing archives from sequence 65524 to 65533 from Production to DR.
2. Stopped the Media recovery Process at DR.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

3. Recover the DR database using simple RMAN recovery.

bash$  rman target /

rman> RECOVER DATABASE UNTIL SEQUENCE 65533 THREAD 1;

4. Start the media recovery process again.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM CURRENT LOGFILE;