RMAN Reset Incarnation Failed: ORA-19910: can not change recovery target incarnation in control file

You cannot the reset of the database if it is in open or nomount state. If you try to perform the reset database to incarnation Command you will get ORA-19910 error message. You have to reset the incarnation in mount state. Now you can perform the recovery from the previous incarnation.


RMAN> reset database to incarnation 2142663;

database reset to incarnation 2142663
ORA-19910: can not change recovery target incarnation in control file

How to reset the incarnation to previous one?
rman catalog rman/rman@rmancat target /

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup mount;
ORACLE instance started.

Total System Global Area 2672361472 bytes
Fixed Size                  2229480 bytes
Variable Size            1962937112 bytes
Database Buffers          553648128 bytes
Redo Buffers              153546752 bytes
Database mounted.

RMAN> reset database to incarnation 2142663;

database reset to incarnation 2142663


See this: Restore database from Previous incarnation
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google