Standby Database ask for old archive log file

reda ibrahim

I try to rebuild Standby from existing Primary DB, everything is going on the right way until I try to open standby database it always needs recover and asking for an old archive log file,

any advice?

SQL> alter database open;

ERROR at line 1:

ORA-10458: standby database requires recovery

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/proddb/PROD/data/system01.dbf'

SQL> recover standby database;

ORA-00279: change 5979878256281 generated at 01/28/2020 06:45:11 needed for

thread 1

ORA-00289: suggestion :

/proddb/PROD/fra/PRODSTDBY/archivelog/2020_08_16/o1_mf_1_19069_%u_.arc

ORA-00280: change 5979878256281 for thread 1 is in sequence #19069

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/proddb/PROD/fra/PRODSTDBY/archivelog/2020_07_30/o1_mf_1_21131_hl67bo6h_.arc

ORA-00310: archived log contains sequence 21131; sequence 19069 required

ORA-00334: archived log:

'/proddb/PROD/fra/PRODSTDBY/archivelog/2020_07_30/o1_mf_1_21131_hl67bo6h_.arc'

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/proddb/PROD/data/system01.dbf'

Shaik Ahmed Ali Bajubair

take the fresh backup and try to build the standy again.

show me the output of "Show all" from rman

reda ibrahim

Thank you very much I already solve this issue , appreciate 😍

Shaik Ahmed Ali Bajubair

Shaik Ahmed Ali Bajubair

reda ibrahim

the issue was missed archive log , after found it everything is ok!

Shaik Ahmed Ali Bajubair

ok thanks