【RMAN】RMAN-20001: target database not found in recovery

一、問題現象

    今天做了一套資料庫的主機及儲存遷移，做完之後，改好備份指令碼，使用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;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30776559/viewspace-2147848/，如需轉載，請註明出處，否則將追究法律責任。