OraFAQ Forum: Backup & Recovery » ORA-19906: recovery target incarnation changed during recovery

Home » RDBMS Server » Backup & Recovery » ORA-19906: recovery target incarnation changed during recovery (Linux)

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

ORA-19906: recovery target incarnation changed during recovery [message #297206]

Wed, 30 January 2008 11:41

basirana
Messages: 25
Registered: July 2006

Junior Member

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: change 1413944 generated at 01/29/2008 12:46:43 needed for thread 1
ORA-00289: suggestion :
/d06/app/testdb/flash_recovery_area/TEST/archivelog/2008_01_30/o1_mf_1_1023_%u_.
arc
ORA-00280: change 1413944 for thread 1 is in sequence #1023

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery

ORA-01112: media recovery not started

Report message to a moderator

Re: ORA-19906: recovery target incarnation changed during recovery [message #297207 is a reply to message #297206]

Wed, 30 January 2008 11:43

basirana
Messages: 25
Registered: July 2006

Junior Member

SQL> select * from V$DATABASE_INCARNATION ;

INCARNATION# RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES
------------ ----------------- --------- ----------------------- ---------
STATUS RESETLOGS_ID PRIOR_INCARNATION#
------- ------------ ------------------
1 1 10-AUG-04 0
PARENT 533845665 0

2 366852 20-JAN-08 1 10-AUG-04
PARENT 644512561 1

3 1417787 29-JAN-08 366852 20-JAN-08
CURRENT 645287485 2

Report message to a moderator

Re: ORA-19906: recovery target incarnation changed during recovery [message #297217 is a reply to message #297207]

Wed, 30 January 2008 12:55

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Change your date format to display time.
And format your post:
Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: ORA-19906: recovery target incarnation changed during recovery [message #297224 is a reply to message #297217]

Wed, 30 January 2008 13:32

basirana
Messages: 25
Registered: July 2006

Junior Member

The format is not coming up properly when I paste...
I am trying to attach the ERROR messages what I am getting in RMAN Database and Target database

Attachment: ERRORS.txt
(Size: 1.46KB, Downloaded 1576 times)

Report message to a moderator

Re: ORA-19906: recovery target incarnation changed during recovery [message #297225 is a reply to message #297224]

Wed, 30 January 2008 13:36

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I was not talking about the error message, I was talking about your query.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN-06004: ORACLE error from recovery catalog database
Next Topic:	Rman Log File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 18:23:41 CDT 2024