Fix RMAN-06004 RMAN-20001: target database not found in recovery catalog

Error Description: Most of the RMAN commands are getting failed with RMAN-20001 error message.
RMAN> list backup summary;

RMAN-00571:
===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===================================================
RMAN-03002: failure of list command at 11/13/2011 03:26:18
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

Resolution:
  1. Connect to RMAN Catalog

$ rman catalog rman/rman@rmancat target rmanbkup/rmanbkup@devqa1
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Nov 13 03:25:49 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEVQA1 (DBID=3967264896)
connected to recovery catalog database
  1. Unregister the database
RMAN>unregister database noprompt;

  1. Register Database to RMAN catalog
RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google