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

denglj

问题描述：重置incarnation时，报错ORA-19910，如下所示：

RMAN>list incarnation;

usingtarget database control file instead of recovery catalog

List ofDatabase Incarnations

DBKey  Inc Key DB Name  DB ID            STATUS  Reset SCN Reset Time

-------------- -------- ---------------- --- ---------- ----------

1       1      ORCL     1642676218       PARENT 1          24-AUG-13

2       2      ORCL     1642676218       PARENT 925702     08-SEP-22

3       3      ORCL     1642676218       CURRENT 938040     08-SEP-22

RMAN>reset database to incarnation 2;

RMAN-00571:===========================================================

RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03009:failure of reset database command on default channel at 09/09/2022 21:15:07

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

异常原因：重置到incarnation2，需要到mount阶段执行.

RMAN>shutdown immediate

databaseclosed

databasedismounted

Oracleinstance shut down

RMAN>startup mount;

connectedto target database (not started)

Oracleinstance started

databasemounted

TotalSystem Global Area    1586708480 bytes

Fixed Size                     2253624 bytes

VariableSize                989859016 bytes

DatabaseBuffers             587202560 bytes

RedoBuffers                   7393280 bytes

RMAN>reset database to incarnation 2;

databasereset to incarnation 2

RMAN>alter database open;

database opened.