OraFAQ Forum: Backup & Recovery » RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is

Home » RDBMS Server » Backup & Recovery » RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is (oracle 10gr2 centos 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is [message #404778]

Sat, 23 May 2009 11:51

kytemanaic
Messages: 55
Registered: February 2009

Member

first of all
I only created a recovery catalog on 21 May I don't think I have catolog the old backup copies.
I also fail to read the documentation before doing a DBPITR
as I realize from

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr006.htm#sthref673

"The main differences between DBPITR within the current incarnation and to an SCN in an ancestor incarnation are that you must reset the incarnation of the database to the incarnation that was current at the target SCN
"

I remember I din remember to restore the control file first time I perform DBPITR within different incarnation.

RMAN> list INCARNATION ;                                                        


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       12      TOMKYTE  3946756354       PARENT  1          30-JUN-2005 19:09:40
1       13      TOMKYTE  3946756354       PARENT  446075     10-MAY-2009 21:14:45
1       14      TOMKYTE  3946756354       PARENT  710178     19-MAY-2009 23:38:26
1       15      TOMKYTE  3946756354       PARENT  712090     20-MAY-2009 00:17:26
1       2       TOMKYTE  3946756354       CURRENT 718855     20-MAY-2009 23:36:59
1       823     TOMKYTE  3946756354       ORPHAN  723015     21-MAY-2009 10:41:53
1       2538    TOMKYTE  3946756354       ORPHAN  724598     21-MAY-2009 11:32:06
1       1596    TOMKYTE  3946756354       ORPHAN  724598     21-MAY-2009 10:49:14

based on the above I decided to reset in incarnation key to 823

according to http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr006.htm#sthref673

"Point-in-Time Recovery to an Ancestor Incarnation"



RMAN> startup force nomount

RUN
{
  # set target time for all operations in the RUN block
  SET UNTIL TIME "to_date('21-MAY-2009 10:42:53','DD-MON-YYYY HH24:MI:SS')"; 
RESTORE CONTROLFILE;
# without recovery catalog, use RESTORE CONTROLFILE FROM AUTOBACKUP
  ALTER DATABASE MOUNT; 
  RESTORE DATABASE;
  RECOVER DATABASE;
}

output as follow

Starting restore at 24-MAY-2009 00:19:21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/TOMKYTE/autobackup/2009_05_21/o1_mf_s_687436920_519hvros_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/TOMKYTE/autobackup/2009_05_21/o1_mf_s_687436920_519hvros_.bkp tag=TAG20090521T104200
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/oradata/tomkyte/control01.ctl
output filename=/u01/oradata/tomkyte/control02.ctl
output filename=/u01/oradata/tomkyte/control03.ctl
Finished restore at 24-MAY-2009 00:19:23

database mounted
released channel: ORA_DISK_1

Starting restore at 24-MAY-2009 00:19:29
Starting implicit crosscheck backup at 24-MAY-2009 00:19:29
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 21 objects
Finished implicit crosscheck backup at 24-MAY-2009 00:19:30

Starting implicit crosscheck copy at 24-MAY-2009 00:19:30
using channel ORA_DISK_1
Crosschecked 19 objects
Finished implicit crosscheck copy at 24-MAY-2009 00:19:30

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/flash_recovery_area/TOMKYTE/autobackup/2009_05_21/o1_mf_s_687438314_519k7bt7_.bkp
File Name: /u01/app/oracle/flash_recovery_area/TOMKYTE/autobackup/2009_05_21/o1_mf_s_687436920_519hvros_.bkp

.....

.....
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/24/2009 00:20:26
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog

it's a bit messy now. and I believe I'm in a terrible mess...I just learning hands-on on my laptop....can't imagine what a terrible mess I am in now......

later I read again
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr006.htm#sthref673

from Using a Time Expression for Database Point-in-Time Recovery

"
for more information on DBPITR to ancestor incarnations, and Oracle Database Backup and Recovery Advanced User's Guide for more information on DBPITR to incarnations that are not ancestors of the current incarnation.

"

the above is terribly wrong.......if I have read carefully what I did is only applicable for backups catalog in recovery catalog and for ancestor backups not orphan incarnation.

I try to read

Oracle Database Backup and Recovery Advanced User's Guide
@
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

but I could not found any documentation on recovery from incarnations from orphan incarnations.

how should I proceed from here?

thanks a lot!

Report message to a moderator