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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s