RMAN-20005: target database name is ambiguous
發生的這個錯誤的由於:
在RMAN CATALOG中,register了一個name叫test的資料庫,後來這個庫被我搞壞了。就重建了一個test的資料庫,名稱沒有更改,又重新register到RMAN CATALOG中。在用CATALOG備份都是沒有問題。後來模擬controlfile/datafile丟失的case,就發生了
RMAN-20005: target database name is ambiguous的錯誤。
由於CATALOG上有兩個不同DBID但是名稱相同的target database,CATALOG不知道要連線哪個target,故報錯。
可以通過以下方式解決:
1. 連線到catalog 上,獲取到dbid的資訊
$ sqlplus rman/rman@db
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 13 14:43:24 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select * from rc_database;
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- -------- ----------------- ---------------
1 2 1943768960 TEST 845248 15-FEB-08
287 288 1947325841 TEST 1 12-MAR-08
新庫比老庫建立的晚,那DBID為 1947325841
2. 確認DBID的資訊:
通過list backup反饋的資訊確認是否正確:
$ rman target / catalog rman/rman@db
Recovery Manager: Release 9.2.0.1.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: test (not mounted)
connected to recovery catalog database
RMAN> set dbid = 1947325841
executing command: SET DBID
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
317 Full 65M DISK 00:00:04 13-MAR-08
BP Key: 319 Status: AVAILABLE Tag: TAG20080313T100953
Piece Name: /backup2/test/test_03jb5dfh_1_1.bak
List of Datafiles in backup set 317
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 70680 13-MAR-08 /backup1/data/test/oradata/undotbs01.dbf
3 Full 70680 13-MAR-08 /backup1/data/test/oradata/test01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
318 Full 127M DISK 00:00:13 13-MAR-08
BP Key: 320 Status: AVAILABLE Tag: TAG20080313T100953
Piece Name: /backup2/test/test_04jb5dfh_1_1.bak
List of Datafiles in backup set 318
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 70680 13-MAR-08 /backup1/data/test/oradata/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
325 Full 2M DISK 00:00:01 13-MAR-08
BP Key: 326 Status: AVAILABLE Tag:
Piece Name: /backup2/test/test_c_c-1947325841-20080313-00
SPFILE Included: Modification time: 28-FEB-08
我只備份了一次新庫,呵呵。毫無疑問,DBID是正確的。
說明:
不要在同一個CATALOG中註冊相同的DBNAME的庫,否則會產生混亂。來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/40239/viewspace-206229/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- iptables:No chain/target/match by the nameAI
- Oracle identifiers :Database NameOracleIDEDatabase
- Oracle identifiers :Global database nameOracleIDEDatabase
- FbxDataType is ambiguous
- Determining the Global Database Name (86)Database
- oracle中instance name 和database name的一點體會OracleDatabase
- CMake Error: add_executable cannot create target ““ because another target with the same name已解決Error
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- RMAN-05541: no archived logs found in target databaseHiveDatabase
- 啟動docker容器時報錯:iptables: No chain/target/match by that name.DockerAI
- Centos 7 docker 啟動容器 iptables 報 No chain/target/match by that nameCentOSDockerAI
- ROS報錯The target name "test" is reserved when CTest testing is enabledROS
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- Bug 13250486 : ADD STANDBY DATABASE FOR TARGET WITH FLASHBACK ON FAILS WITH ERRDatabaseAI
- Duplicating a Database Without Recovery Catalog or Target ConnectionDatabase
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- How to Rename Database/Change DB_NAME or ORACLE_SID/Instance Name-15390.1DatabaseOracle
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- 【RMAN】RMAN-20001: target database not found in recoveryDatabase
- 【RMAN】RMAN-05001: auxiliary filename conflicts with the target databaseUXDatabase
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- 使用Duplicate target database命令恢復線上oracle datagard備庫DatabaseOracle
- RMAN-20001: target database not found in recovery catalogDatabase
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- 【ORA-02011】duplicate database link nameDatabase
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- ORA-01103: database name 'ORCLDG' in control file is not 'ORCL'Database
- 使用oracle 11g rman新特性 duplicate target database for standby from active database 建立物理dataguard並開啟RealOracleDatabase
- ORA-16047: DGID mismatch between destination setting and target databaseDatabase
- 11gR2 DBCA建立資料庫global database name長度及db_name長度限制8位問題資料庫Database
- DB_NAME&TANCE_NAME&DB_UNIQUE_NAME&ORACLE_SID&GLOBAL_NAME&DB_DOMAIN&SERVICE_NAMEOracleAI
- memory_max_target,memory_target,pga_aggregate_target,sga_target
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- oracle 10g rman duplicate target database for standby會自動新增臨時檔案Oracle 10gDatabase
- memory_target、sga_target、pga_target的設定
- Openfiler配置ISCSI Target及FC Target
- RMAN-20002: target database already registered in recovery catalog 解決方法Database