SQL Query to fetch dataguard sync status after resetlogs

SQL Query to fetch dataguard sync status after reset logs

You may run both the below query on Primary site:

select 'PROD = '||max(a.sequence#) from v$archived_log a join v$database_incarnation b using (resetlogs_id) where b.status = 'CURRENT';

select 'DR   = '||max(a.sequence#) from v$archived_log a join v$database_incarnation b using (resetlogs_id) where b.status = 'CURRENT' and a.applied= 'YES';

The result should look like below:

PROD = 91678

  

DR   = 91678

----

[SOLVED] - RMAN-03002 RMAN-12009 RMAN-12017

RMAN-03002 RMAN-12009 RMAN-12017

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2017 21:25:09
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12017: could not locate pieces of backup set key 10400

Issue:

RMAN> catalog start with '/backup1/rman/';
RMAN> recover database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2017 21:25:09
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12017: could not locate pieces of backup set key 10400

Solution:

RMAN> catalog backuppiece '/backup1/rman/1_gtmh8n3v_20110712.rmb';
RMAN> recover database;

Note: Catalog backup piece manually.