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

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Latham viewed 'Show Error Returns with No errors: How to find out' 37 mins ago

A visitor from Kamata viewed 'How to Use ORADEBUG to Find out Trace file name' 1 hr 41 mins ago

A visitor from Yeongdeungpo-gu viewed 'What is Oracle BBED Tool? How to make it Available' 2 hrs 6 mins ago

A visitor from Taganrog viewed 'Oracle 11gR2 Impdp DATA_OPTIONS SKIP_CONSTRAINT_ER' 3 hrs 32 mins ago

A visitor from Rancho palos verdes viewed 'How to disable all constraints on a table or schem' 3 hrs 43 mins ago

Real-time | Get Script | More Info