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

I tried to reset the incarnation to its previous state when I received the following error below:


RMAN> LIST INCARNATION;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TECH       4459792587       PARENT  1           18-MAR-15
2       2       TECH       4459792587       CURRENT 32752735843 15-SEP-22


RMAN> RESET DATABASE TO INCARNATION 1;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset database command on default channel at 09/15/2022 11:29:58
ORA-19910: can not change recovery target incarnation in control file

After some analysis, I acknowledge that the database was OPEN. Therefore, to change the incarnation, I bounced the database, started it in the MOUNT state, and executed the operation to shift the incarnation, so it finished successfully. The evidence of this operation can be seen below:


SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             436208824 bytes
Database Buffers          624951296 bytes
Redo Buffers                5541888 bytes
Database mounted.
SQL>


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database: TECH (DBID=4459792587, not open)

RMAN> RESET DATABASE TO INCARNATION 1;

using target database control file instead of recovery catalog
database reset to incarnation 1

RMAN> LIST INCARNATION;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TECH       4459792587       CURRENT 1          18-MAR-15
2       2       TECH       4459792587       ORPHAN  32752735843 15-SEP-22

Related posts

Leave a Comment