RMAN-20002: target database already registered in recovery catalog 解決方法

最新推荐文章于 2023-10-16 10:11:32 发布

转载最新推荐文章于 2023-10-16 10:11:32 发布 · 358 阅读

本文记录了一次使用RMAN进行数据库备份时遇到的错误及解决过程。主要问题为备份失败，错误信息显示数据库实例未设置，并提示需要删除并重建目录。尝试注册数据库时发现目标数据库已在恢复目录中注册。

报错信息：

Starting backup at 20-MAR-08
released channel: gnd
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/20/2008 17:27:19
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database in carnation not set

[@more@]

catalog需要删除然后重新建立。

RMAN> create catalog

recovery catalog already exists

RMAN> register database ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 03/20/2008 17:30:24
RMAN-20002: target database already registered in recovery catalog

RMAN> drop catalog

recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal

RMAN> drop catalog

recovery catalog dropped

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1001243/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1001243/

标签

#数据库