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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SAXParseException的錯誤解決之二Exception
- Linux下錯誤解決方案Linux
- latex 錯誤以及解決方案
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- ORA-28000錯誤解決方案
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- Hadoop常見錯誤及解決方案Hadoop
- SSL錯誤ssl connect error 35的解決方案Error
- PbootCMS中常見的錯誤提示及其解決方案boot
- TCP網路除錯助手提示錯誤:“1035:未知錯誤” 解決方案TCP除錯
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- CS0234 錯誤,奇葩bug,解決方案
- vagrant homestead 錯誤記錄以及解決方案
- oracle11g dataguard切換Oracle
- IDEA發生“Error:java: 錯誤: 不支援發行版本 5”錯誤的解決方案IdeaErrorJava
- No bean named 'xxx' is defined錯誤,原因及解決方案Bean
- 訪問 HTTPS 網站時的 SSL 錯誤解決方案HTTP網站
- photoshop匯出png發生未知錯誤的解決方案,ps匯出發生未知錯誤怎麼解決
- 真機除錯出現 application installation failed 錯誤 解決方案除錯APPAI
- Ocelot錯誤解決
- navicat連線MySQL8.0.11報2059錯誤的解決方案MySql
- Can't Connect to MySQL Server on IP Address (10061) 錯誤的解決方案MySqlServer
- IIS 7.5 解析錯誤 命令執行漏洞解決方案
- java:錯誤:不支援發行版本1.4解決方案Java
- 建立python虛擬環境virtualenv錯誤怎麼解決?Python
- Windows下make clean指令錯誤[錯誤碼2](系統找不到指定檔案)的解決方案Windows
- Windows下使用python庫 curses遇到錯誤訊息的解決方案WindowsPython
- undefined reference to錯誤的解決方法Undefined
- Cocopods的升級錯誤解決
- ORA-12005 錯誤的解決
- DATAGUARD中手工處理日誌GAP
- 關於ESLint: Delete `␍`(prettier/prettier) 錯誤解決方案(3種)EsLintdelete
- 平臺配置及測試錯誤提示及解決方案
- ElasticSearch實戰系列十一: ElasticSearch錯誤問題解決方案Elasticsearch
- DataGuard ORA-01111檔案建立失敗問題解決
- 解決 Python UnicodeEncodeError 錯誤PythonUnicodeError
- 7.Hibernate一對多關係建立與錯誤解決
- Intellij IDEA使用@Autowired註解,出現could not autowire錯誤,解決方案IntelliJIdea
- React 中 呼叫 lodash.debounce 不錯誤繫結 this 解決方案React