Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Standby Database ask for old archive log file

reda ibrahimAug 16 2020 — edited Aug 16 2020

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'

Comments
Post Details
Added on Aug 16 2020
6 comments
246 views