RMAN-20005: target database name is ambiguous
RMAN>RESTORE CONTROLFILE FROM TAG 'PR_WEEKLY_INCR0';
Starting restore at 26-OCT-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/26/2020 09:43:38
RMAN-12010: automatic channel allocation initialization failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005: target database name is ambiguous
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/26/2020 09:43:38
RMAN-12010: automatic channel allocation initialization failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005: target database name is ambiguous
Cause:
Multiple registration of the database in catalog. Run the query below against catalog database to find out the duplicate entry
SQL>SELECT DB.DB_KEY,DB.DB_ID, DB.CURR_DBINC_KEY, DBINC.DB_NAME
FROM DB, DBINC
WHERE DB.CURR_DBINC_KEY = DBINC.DBINC_KEY
AND DBINC.DB_NAME = 'UC43P' ;
FROM DB, DBINC
WHERE DB.CURR_DBINC_KEY = DBINC.DBINC_KEY
AND DBINC.DB_NAME = 'UC43P' ;
DB_KEY DB_ID CURR_DBINC_KEY DB_NAME
10673459 3054236580 10673460 ORCL1P
10268423 3051001234 10268424 ORCL1P
10673459 3054236580 10673460 ORCL1P
10268423 3051001234 10268424 ORCL1P
Solution:
Identify the correct DB ID of the database.
set the dbid and re-run the restore command
RMAN> set dbid=3054236580;
RMAN>RESTORE CONTROLFILE FROM TAG 'PR_WEEKLY_INCR0';
executing command: SET DBID
database name is "ORCL1P" and DBID is 3054236580
RMAN>RESTORE CONTROLFILE FROM TAG 'PR_WEEKLY_INCR0';
executing command: SET DBID
database name is "ORCL1P" and DBID is 3054236580
executing command: SET until clause
Starting restore at 26-OCT-20
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece c-3054236580-20201024-04
channel ORA_SBT_TAPE_1: piece handle=c-3054236580-20201024-04 tag=TAG20201024T093702
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:03
output file name=/ora00_data1/ORCL1P/control/control_01.ctl
output file name=/ora00_data2/ORCL1P/control/control_02.ctl
output file name=/ora00_data3/ORCL1P/control/control_03.ctl
Finished restore at 26-OCT-20
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece c-3054236580-20201024-04
channel ORA_SBT_TAPE_1: piece handle=c-3054236580-20201024-04 tag=TAG20201024T093702
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:03
output file name=/ora00_data1/ORCL1P/control/control_01.ctl
output file name=/ora00_data2/ORCL1P/control/control_02.ctl
output file name=/ora00_data3/ORCL1P/control/control_03.ctl
Finished restore at 26-OCT-20
Comments
Post a Comment