Site icon IT Tutorial

RMAN-20005: target database name is ambiguous

Hi,

Sometimes You can get “RMAN-20005: target database name is ambiguous ” error.

 

Details of error are as follows.

RMAN-20005: target database name is ambiguous
Cause: two or more databases in the recovery catalog match this name
Action: None
RMAN-03002: failure of restore command at 12/04/2020 14:24:20
RMAN-06004: ORACLE error from recovery catalog database: 
RMAN-20005: target database name is ambiguous


This error is related with the Database ID in the Catalog database.

To solve this error, Firstly set DBID and try again.

 

 

RMAN> set DBID=1343463786;

 

Try again, if it is not solved then connect catalog database and run the unregister and register database .

 

connect catalog user/pwd@CATALOG_DB
connect target /

RMAN> unregister database;
RMAN> register database;

 

 


Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version