My Oracle Support Banner

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 later
Information 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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.