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


I try to reset the incarnation to previous state without knowing that database is in open state. This error is because of consistency mismatch prevention when database is in open mode.

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 10/12/2021 22:56:33
ORA-19910: can not change recovery target incarnation in control file


Bounce the database to mount state

kish@PRIM>shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
kish@PRIM>startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 3238002688 bytes
Fixed Size                  2929600 bytes
Variable Size            1946160192 bytes
Database Buffers         1275068416 bytes
Redo Buffers               13844480 bytes
Database mounted.
Disconnected from Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

Reset the incarnation

[oracle@dc01x01 ~]$ rman target /

Recovery Manager: Release - Production on Tue Oct 12 23:02:09 2021

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

connected to target database: DBX00 (DBID=2195240283, not open)

RMAN> reset database to incarnation 1;

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

Leave a Reply