RMAN-20004 and RMAN-06004 Error

RMAN-20004 and RMAN-06004 Error

Rman is the oracle utility to take the physical backup of the database. It will help DBA to take backup and restore the database completely and incomplete recovery scenario. It take backup at block level. We can perform both full or incremental level hot backup with RMAN.

RMAN maintained own catalog Database which having history for all register databases in catalog. It is easy to maintain when you have huge environment and want to see the backup report which is successful and failed backup.

Errors:
RMAN-06004: ORACLE error from recovery catalog database.
RMAN-20004: target database name does not match name in recovery catalog;

Caused:

1. When we performed cloning activity or refresh activities, then DBID of our database is changed during this process.
2. RMAN catalog have entry of the same DB name already exists

Solution:
We first check if we needed the recovery catalog of the database if not needed we unregistered the old one database which having same name as current one and re-register the new database as follows:

RMAN-06004: ORACLE error from recovery catalog database.
RMAN-20004: target database name does not match name in recovery catalog;

rman rcvcat username/password@rmandatabase  target /
rman > unregister database;
rman > register database;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.