ORA-19910 异常

问题描述:重置incarnation时报错ORA-19910如下所示:
RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key 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
异常原因:重置到incarnation 2需要到mount阶段执行.
RMAN> shutdown immediate

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 1586708480 bytes

Fixed Size 2253624 bytes
Variable Size 989859016 bytes
Database Buffers 587202560 bytes
Redo Buffers 7393280 bytes

RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN> alter database open;

database opened