RMAN-06003: ORACLE error from target database: string with ORA-01152: file 3 was not restored from a sufficiently old backup

Hi,

Sometimes You can get “RMAN-06003: ORACLE error from target database: string ” error.

Details of error are as follows.

RMAN-06003: ORACLE error from target database: string

When I recover database using the following RMAN Command, I got the following errors.

RMAN> run {
allocate channel t1 type disk;
alter database mount;
restore database;
set until logseq=634 thread=1;
recover database;
alter database open resetlogs;
release channel t1;
}

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: alter db
RMAN-06003: ORACLE error from target database: ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '//<path>/<file_name>.dbf.dbf'
RMAN-06097: text of failing SQL statement: alter database open resetlogs
RMAN-06099: error occurred in source file: krmk.pc, line: 22116

If the recovery had specified ‘set until logseq 635 thread 1;’, the recovery would have completed successfully as the last scn to apply in sequence 634 is 419899 which is 3 changes beyond the datbase file change#.

Try again as follows.

RMAN> run {
allocate channel t1 type disk;
alter database mount;
restore database;
set until logseq=635 thread=1;
recover database;
alter database open resetlogs;
release channel t1;
}

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/