IT Tutorial

RMAN-20208: UNTIL CHANGE is before RESETLOGS change


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,

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.


 967 views last month,  2 views today

Exit mobile version