On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,524 Users
  • 2,269,754 Discussions
  • 7,916,770 Comments

Discussions

Standby Database ask for old archive log file

reda ibrahim
reda ibrahim Member Posts: 3 Green Ribbon
edited Aug 16, 2020 4:33AM in Data Guard

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'

Answers