RMAN Duplicate Failed With Following ORA-01152 RMAN-06136 RMAN-06097
(Doc ID 272327.1)
Last updated on JANUARY 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
Rman duplicate failed with following
RMAN-03022: compiling command: alter db
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: alter db
RMAN-06136: ORACLE error from auxiliary database: ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/<path>/rbs1.dbf'
RMAN-06097: text of failing SQL statement: alter database open resetlogs
RMAN-06099: error occurred in source file: krmk.pc, line: 22291
Whe you try to restore the same backup from rman and do the recovery using sqlplus it gave the following error
recover database using backup controlfile until time '2004-04-30:11:
35:00';
ORA-00279: change 49219322 generated at 04/25/2004 20:00:06 needed for
thread 1
ORA-00289: suggestion : /<path>/arch_1_8367.arc
ORA-00280: change 49219322 for thread 1 is in sequence #8367
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00331: log version 8.1.0.0.0 incompatible with ORACLE version 8.0.0.0.0
ORA-00334: archived log: '/<path>/arch_1_8367.arc'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/<path>/rbs1.dbf'
SVRMGR> show parameter comp
+Compatibility was not set in init.ora file of auxiliary database and going for default comp 8.0
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |