重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-19910: can not change recovery target incarnation in control file [打印本页]

作者: denglj 时间: 2022-9-16 18:00
标题: ORA-19910: can not change recovery target incarnation in control file

问题描述：重置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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)