ORACLE11g DataGuard手工建立錯誤的解決方案(二)
問題現象:
[oracle@linfy1 admin]$ rman target / auxiliary sys/oracle@STANDBY1
Starting backup at 01-MAR-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=30 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=125 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/01/2015 10:36:46
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/01/2015 10:36:46
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server
問題原因:
主備庫的tnsnames.ora檔案的配置不正確
解決方案
1、在Target Server端新增到Auxiliary DB的tnsnames.ora,即與Auxiliary server端使用相同的tnsnames entry
2、主備庫的tnsnames.ora檔案要配置正確
3、參考MetaLink的描述(Doc ID 1144273.1)
[oracle@linfy1 admin]$ rman target / auxiliary sys/oracle@STANDBY1
Starting backup at 01-MAR-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=30 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=125 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/01/2015 10:36:46
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/01/2015 10:36:46
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server
問題原因:
主備庫的tnsnames.ora檔案的配置不正確
解決方案
1、在Target Server端新增到Auxiliary DB的tnsnames.ora,即與Auxiliary server端使用相同的tnsnames entry
2、主備庫的tnsnames.ora檔案要配置正確
3、參考MetaLink的描述(Doc ID 1144273.1)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/543979/viewspace-1669110/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE11g DataGuard手工建立錯誤的解決方案(一)Oracle
- DataGuard ORA-10458錯誤解決方案
- MySQL建立二進位制日誌產生1067錯誤的解決方案MySql
- SAXParseException的錯誤解決之二Exception
- latex 錯誤以及解決方案
- ORACLE11G解決ORA-00845錯誤Oracle
- 建立cache group 時遇到 錯誤5120 時候的解決方案
- Linux下錯誤解決方案Linux
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- Oracle11g 手工建立資料庫Oracle資料庫
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- ORA-28000錯誤解決方案
- ORA-07445: 錯誤解決方案
- ORA-00054錯誤解決方案(摘)
- ORA-00845的錯誤與解決方案
- SVN 遇到的一些錯誤解決方案
- PbootCMS中常見的錯誤提示及其解決方案boot
- Hadoop常見錯誤及解決方案Hadoop
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- MySQL插入資料1366錯誤解決方案MySql
- 開發常見錯誤及解決方案
- MySQL錯誤Incorrect file format解決方案薦MySqlORM
- Java java.lang.ExceptionInInitializerError 錯誤解決方案JavaExceptionError
- informatica SORT_40406 錯誤解決方案ORM
- SQL Server 錯誤程式碼:17058 。解決方案SQLServer
- DataGuard切換報ora-16009錯誤的解決辦法
- SSL錯誤ssl connect error 35的解決方案Error
- MySQL連線錯誤(10048)的解決方案MySql
- [轉]MySql錯誤程式碼1045的解決方案MySql
- linux oracle 建立informix dblink 錯誤解決LinuxOracleORM
- ORA-01578錯誤的解決方法 ( 二)
- vagrant homestead 錯誤記錄以及解決方案
- JNI命令列下編譯錯誤解決方案命令列編譯
- 使用JPEGImageEncoder提示Access restriction:錯誤 解決方案REST
- Unsupported major.minor version 51.0 錯誤解決方案
- ORA-01658 錯誤之解決方案
- ant構建時出現錯誤解決方案
- Oracle11g Dataguard錯誤ORA-02097:ORA-16053:Oracle