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'