学堂 学堂 学堂公众号手机端

ORA-19910 异常

lewis 4年前 (2021-02-26) 阅读数 4 #技术
问题描述:重置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



版权声明

本文仅代表作者观点,不代表博信信息网立场。

热门