| 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
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
