Hi Team,
We have created Oracle primary(PRIMARY_DB) and standby databases(STANDBY_DB). We have also created backups for both the primary and standby databases. After some time, we performed a switchover to the standby database STANDBY_DB. Now STANDBY_DB is my Primary Database and PRIMARY_DB became standby.
Now we are trying to restore the STANDBY_DB using backups created on the same DB when it was a standby which is failing.
For normal DB restore we restore the snapshot at the storage level and apply archive logs to the given PIT, same we tried to restore STANDBY_DB which did not work.
starting media recovery
archived log for thread 1 with sequence 55 is already on disk as file /opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217220927_20241217223126/std18dec1056/archivelog/2024_12_18/thread_1_seq_55.268.1188023487
archived log for thread 1 with sequence 56 is already on disk as file /opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217223126_20241217230034/std18dec1056/archivelog/2024_12_18/thread_1_seq_56.269.1188025235
archived log for thread 1 with sequence 57 is already on disk as file /opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217230034_20241217232951/std18dec1056/archivelog/2024_12_18/thread_1_seq_57.270.1188026993
archived log file name=/opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217220927_20241217223126/std18dec1056/archivelog/2024_12_18/thread_1_seq_55.268.1188023487 thread=1 sequence=55
archived log file name=/opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217223126_20241217230034/std18dec1056/archivelog/2024_12_18/thread_1_seq_56.269.1188025235 thread=1 sequence=56
archived log file name=/opt/era_base/tempdir/era_recovery_staging_area/logs_0/20241217230034_20241217232951/std18dec1056/archivelog/2024_12_18/thread_1_seq_57.270.1188026993 thread=1 sequence=57
Oracle Error:
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: '+DATADG_STD18DEC1056/STD18DEC1056/DATAFILE/system.258.1188021645'
So I would like to know whether restoring the STANDBY_DB(which is the primary DB now after the switchover) using the backups created when it was a standby DB is allowed or now?
If it is allowed then what differently should we do to restore DB for such cases?