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
Cause: This message should be accompanied by other error message(s) indicating the cause of the error.
Action: Check the accompanying errors.
RMAN-06003: ORACLE error from target database: ORA-01152: file 3 was not restored from a sufficiently old backup
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/