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

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Website Stats