ORA-19910: can not change recovery target incarnation in control file
Cause:
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
Workaround:
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.
kish@PRIM>exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 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 12.1.0.2.0 - 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