Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19909: datafile 1 belongs to an orphan incarnation

939393Apr 7 2017 — edited Apr 12 2017

Dear Guru's,

OS:- AIX

DB Version:- 11.2.0.3

I have the RMAN offline DB backup. I am trying to restore the DB to another machine with same Directory structure. DB is restored properly but when trying to recovery the DB gettinge below error:-

RMAN> run{

2> ALLOCATE CHANNEL c1 DEVICE TYPE disk;

3> ALLOCATE CHANNEL c2 DEVICE TYPE disk;

4> ALLOCATE CHANNEL c3 DEVICE TYPE disk;

5> ALLOCATE CHANNEL c4 DEVICE TYPE disk;

6> recover database;

7> release channel c1;

8> release channel c2;

9> release channel c3;

10> release channel c4;

11> }

allocated channel: c1

channel c1: SID=2283 device type=DISK

allocated channel: c2

channel c2: SID=11 device type=DISK

allocated channel: c3

channel c3: SID=2284 device type=DISK

allocated channel: c4

channel c4: SID=12 device type=DISK

Starting recover at 07-APR-17

starting media recovery

media recovery failed

released channel: c1

released channel: c2

released channel: c3

released channel: c4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 04/07/2017 20:10:32

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

start until cancel using backup controlfile

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/d01/app/oracle/oradata/orcl/system01.dbf'

Archive logs which are generated before the day offline backup is done and after the day backup is done is taken and cataloged with the RMAN. Even disable the flashback in mount mode.But still getting the error

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2017
Added on Apr 7 2017
20 comments
14,138 views