Home » RDBMS Server » Backup & Recovery » ORA-19906: recovery target incarnation changed during recovery (Linux)
ORA-19906: recovery target incarnation changed during recovery [message #297206] Wed, 30 January 2008 11:41 Go to next message
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
Re: ORA-19906: recovery target incarnation changed during recovery [message #297207 is a reply to message #297206] Wed, 30 January 2008 11:43 Go to previous messageGo to next message
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
Re: ORA-19906: recovery target incarnation changed during recovery [message #297217 is a reply to message #297207] Wed, 30 January 2008 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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
Re: ORA-19906: recovery target incarnation changed during recovery [message #297224 is a reply to message #297217] Wed, 30 January 2008 13:32 Go to previous messageGo to next message
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 304 times)
Re: ORA-19906: recovery target incarnation changed during recovery [message #297225 is a reply to message #297224] Wed, 30 January 2008 13:36 Go to previous message
Michel Cadot
Messages: 64120
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
Previous Topic: RMAN-06004: ORACLE error from recovery catalog database
Next Topic: Rman Log File
Goto Forum:
  


Current Time: Tue Dec 06 12:07:51 CST 2016

Total time taken to generate the page: 0.06764 seconds