Hi,
Sometimes You can get “RMAN-20208: UNTIL CHANGE is before RESETLOGS change ” error.
Details of error are as follows.
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
Cause: UNTIL CHANGE cannot be less than the database RESETLOGS change.
Action: Check the UNTIL CHANGE. If the database needs to be restored to an old incarnation,
use the RESET DATABASE TO INCARNATION command.
This error is related with autobackups in FRA ( Flash Recovery Area ), There are backup files but they are belonged to different incarnation than the available backups current incarnation.
To solve this error, reset the db_recovery_file_dest and db_recovery_file_dest_size parameters, and RMAN will not look for these files in the FRA.
SQL> alter system reset db_recovery_file_dest_size scope=spfile sid='*'; System altered. SQL> alter system reset db_recovery_file_dest scope=spfile sid='*'; System altered.
Restart database as follows.
SQL> shutdown immediate; SQL> startup
Then try to restore again.
If it is not solved with this action, then Catalog these backup pieces again as follows. Then restore and recover again as follows.
RMAN> catalog start with '/oracle/backup/';
run {
set until time "to_date('28/04/2020 16:30:00′,'dd/mm/yyyy hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;
}
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/