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

标题: RMAN-03009 ORA-01407 during full resync of recovery catalog [打印本页]

作者: 刘泽宇 时间: 2025-9-13 17:10
标题: RMAN-03009 ORA-01407 during full resync of recovery catalog
现象：
RMAN-03009 ORA-01407 during full resync of recovery catalog.

RMAN debug trace:
===========
DBGMISC:    ENTERED krmztrc [06:27:40.093]
DBGRESYNC:    channel default: Calling checkThread for thread 3 with sequence 1 [06:27:40.093] (resync)  <<<<<<<<<<<<<<<<<< Thread#3 sequence#1.
DBGMISC:    EXITED krmztrc [06:27:40.093] elapsed time [00:00:00:00.000]
DBGRPC:       krmxrpc - channel default kpurpc2 err=1407 db=rcvcat proc=AMERICAS_19C_CAT1.DBMS_RCVCAT.CHECKTHREAD excl: 126  <<<<<<<<<<<

原因：
Standby controlfile was having some rogue information from thread#3 sequence#1 which does not exist at all as it is a 2 node RAC primary and standby database.

处理方法：
Recreate the standby controlfile and execute the resync command:

Step By Step Guide On How To Recreate Standby Control File When Datafiles Are On ASM And Using Oracle Managed Files (Doc ID 734862.1)
Steps to recreate a Physical Standby Controlfile (Doc ID 459411.1)

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