您好,登錄后才能下訂單哦!
這篇文章主要講解了“DG搭建常見(jiàn)問(wèn)題處理的方法是什么”,文中的講解內(nèi)容簡(jiǎn)單清晰,易于學(xué)習(xí)與理解,下面請(qǐng)大家跟著小編的思路慢慢深入,一起來(lái)研究和學(xué)習(xí)“DG搭建常見(jiàn)問(wèn)題處理的方法是什么”吧!
1、ORA-09925報(bào)錯(cuò)
報(bào)錯(cuò)1:
connected to auxiliary database (not started) released channel: prmy1 released channel: prmy2 released channel: prmy3 released channel: prmy4 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/27/2018 10:48:43 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925
原因:備庫(kù)adump文件不存在
解決:
mkdri -p $ORACLE_HOME/admin/db_unique_name/adump
例如:
mkdir -p $ORACLE_BASE/admin/mssdbdg/adump
2、RMAN-05537報(bào)錯(cuò)
報(bào)錯(cuò)2:
Starting Duplicate Db at 27-JUL-18 released channel: prmy1 released channel: prmy2 released channel: prmy3 released channel: prmy4 released channel: stby RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/27/2018 10:57:28 RMAN-05501: aborting duplication of target database RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause
原因:備庫(kù)跑了duplicate腳本,沒(méi)有刪除spfile文件,重新啟動(dòng)數(shù)據(jù)庫(kù)到nomount
解決:先刪除spfile文件,重新啟動(dòng)數(shù)據(jù)庫(kù)到nomount
3、ORA-17628: Oracle error 19505 報(bào)錯(cuò)
contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '/ORADATA/RESNETDBDG/control01.ctl'; restore clone primary controlfile to '/ORADATA/fast_recovery_area/RESNETDBDG/control02.ctl' from '/ORADATA/RESNETDBDG/control01.ctl'; } executing Memory Script Starting backup at 26-JUL-2018 18:42:20 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/26/2018 18:42:21 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 07/26/2018 18:42:21 ORA-17628: Oracle error 19505 returned by remote Oracle server
原因:目標(biāo)端路徑不存在,可能是文件系統(tǒng)路徑不存在,也可能是權(quán)限不夠,如果是ASM,請(qǐng)確認(rèn)磁盤組是否存在,磁盤的權(quán)限是否正確
4、ORA-01017報(bào)錯(cuò)
這里是報(bào)密碼錯(cuò)誤,SYS用戶登錄采用的是密碼文件認(rèn)證的方法,所以需要確保密碼文件可讀寫和密碼文件的名字中的ORACLE_SID與監(jiān)聽中的ORACLE_SID是對(duì)應(yīng)的。密碼錯(cuò)誤分很多情況。
4.1 第一次搭建時(shí)報(bào)密碼錯(cuò)誤
4.1.1 密碼文件不一致
通過(guò)在主庫(kù)的一個(gè)節(jié)點(diǎn)修改密碼后,將此節(jié)點(diǎn)的密碼文件復(fù)制給其它所有的節(jié)點(diǎn),包括主庫(kù)的節(jié)點(diǎn)和備庫(kù)的所有的節(jié)點(diǎn),確認(rèn)Oracle用戶有對(duì)寫的權(quán)限。
4.1.2 目標(biāo)端報(bào)密碼錯(cuò)誤
已經(jīng)完成4.1.1的操作,但是仍然報(bào)密碼錯(cuò)誤。這個(gè)時(shí)候很可能是靜態(tài)監(jiān)聽里面的數(shù)據(jù)庫(kù)ORACLE_SID與密碼文件中的SID不一致。
5、日志不傳輸?shù)絺鋷?kù)分析方法
SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE TARGET='STANDBY';
查看ERROR的報(bào)錯(cuò)代碼,根據(jù)報(bào)錯(cuò)代碼來(lái)解決問(wèn)題。
6、ORA-00845報(bào)錯(cuò)
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 07/30/2018 02:22:10 RMAN-03015: error occurred in stored script Memory Script RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system
由于使用AMM功能,但是SHM大小沒(méi)有AMM那么大,所有需要重新SHM,并指定跟AMM相同的大小
mount -o remount,default,size=102G /dev/shm
修改/etc/fstab中的值
7、監(jiān)聽配置沒(méi)問(wèn)題,sqlplus測(cè)試沒(méi)問(wèn)題,tnsping也沒(méi)問(wèn)題,可還是報(bào)下邊錯(cuò)誤
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/05/2018 02:30:01 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on prmy2 channel at 08/05/2018 02:30:01 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 RMAN>
解決:把tnsnames.ora的內(nèi)容,在grid的network/admin下復(fù)制一份??梢栽贛OS上查看RMAN Active Duplicate on RAC fails with ORA-17629 and ORA-17627: ORA-12154 (文檔 ID 1982003.1)
8、duplicate出錯(cuò),查看原因是原庫(kù)有兩個(gè)數(shù)據(jù)文件沒(méi)有使用OMF格式,無(wú)法傳過(guò)去。
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/05/2018 20:42:25 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on prmy4 channel at 08/05/2018 20:01:35 ORA-17628: Oracle error 19505 returned by remote Oracle server RMAN-03009: failure of backup command on prmy4 channel at 08/05/2018 20:01:20 ORA-17628: Oracle error 19505 returned by remote Oracle server
解決:查看錯(cuò)誤代碼:MOS 1331986.1
注意,做之前先確定一下是不是OMF文件,若不是,先在asm的子層建好目錄或在腳本里把子層目錄寫好。
感謝各位的閱讀,以上就是“DG搭建常見(jiàn)問(wèn)題處理的方法是什么”的內(nèi)容了,經(jīng)過(guò)本文的學(xué)習(xí)后,相信大家對(duì)DG搭建常見(jiàn)問(wèn)題處理的方法是什么這一問(wèn)題有了更深刻的體會(huì),具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云,小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章,歡迎關(guān)注!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。