一、问题现象
今天做了一套数据库的主机及存储迁移,做完之后,改好备份脚本,使用NBU备份时,报出如下的错误:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2017 16:27:26
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery
二、问题解析
查看RMAN错误,报错原因是在数据库迁移之后,新的数据库没有在recovery catalog中注册。
oracle@C01TEST03:/home/oracle>oerr rman 20001
20001, 1, "target database not found in recovery catalog"
// *Cause: target database is not found in the recovery catalog
// *Action: make sure that the target database is registered in the recovery recovery catalog
三、解决方法
在数据库所在的server上,进行数据库注册
C01TEST03上:
oracle@C01TEST03:/home/oracle>rman target / catalog RMAN_MTH_C01TEST03_PROD/RMAN_MTH_C01TEST03_PROD@catalog
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 28 10:22:01 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: MTH (DBID=3150883311)
connected to recovery catalog database
RMAN>register database;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30776559/viewspace-2147848/ ,如需转载,请注明出处,否则将追究法律责任。