您好,登錄后才能下訂單哦!
這篇文章給大家介紹Oracle 11g RAC中INTERMEDIATE Stuck Archiver狀態(tài)的解決方法,內(nèi)容非常詳細(xì),感興趣的小伙伴們可以參考借鑒,希望對大家能有所幫助。
新建的庫,空跑了幾天之后,使用pl/sql工具連接數(shù)據(jù)庫一節(jié)點(diǎn),報沒有監(jiān)聽,然后查看監(jiān)聽狀態(tài):
rac1:/home/oracle@grid> lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-5月 -2018 09:53:37
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
二節(jié)點(diǎn)監(jiān)聽狀態(tài):
rac2:/grid/app/11.2.0/network/admin@grid> lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-52018 09:48:02
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 11-42018 17:19:45
Uptime 20 days 16 hr. 28 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid/app/11.2.0/network/admin/listener.ora
Listener Log File /grid/app/grid/diag/tnslsnr/rac2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=136.64.194.180)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=136.64.194.182)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "rac" has 1 instance(s).
Instance "rac2", status READY, has 1 handler(s) for this service...
The command completed successfully
然后查看集群狀態(tài)
rac1:/home/oracle@grid> crsctl stat res -t
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
省略
ora.rac.db
1 ONLINE INTERMEDIATE rac1 Stuck Archiver
2 ONLINE INTERMEDIATE rac2 Stuck Archiver
ora.rac1.vip
1 ONLINE INTERMEDIATE rac2 FAILED OVER
ora.rac2.vip
1 ONLINE ONLINE rac2
發(fā)現(xiàn)現(xiàn)在數(shù)據(jù)庫實(shí)例變成了INTERMEDIATE Stuck Archiver狀態(tài),然后1節(jié)點(diǎn)的vip也failed over了
然后繼續(xù)分析alert日志,發(fā)現(xiàn)如下報錯信息
ARC1: Error 19809 Creating archive log file to '+ARCH'
Errors in file /oracle/diag/rdbms/rac/rac1/trace/rac1_arc3_21444.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 6005194752 bytes is 100.00% used, and has 0 remaining bytes available.
好像跟歸檔目錄有關(guān)系,然后去看歸檔情況
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +ARCH
db_recovery_file_dest_size big integer 5G
發(fā)現(xiàn)歸檔使用ASM存儲的+ARCH區(qū)域,而且只能使用5G的大小,這也就發(fā)現(xiàn)了問題的原因,雖然我們有100g的歸檔空間,現(xiàn)在只能使用5G,所以歸檔目錄無法寫入了
開始解決問題
SQL> alter system set db_recovery_file_dest_size=100G;
System altered.
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +ARCH
db_recovery_file_dest_size big integer 100G
再看集群狀態(tài),發(fā)現(xiàn)集群狀態(tài)恢復(fù)正常,然后啟動一節(jié)點(diǎn)監(jiān)聽
rac1:/home/oracle@grid> srvctl start listener -l LISTENER
故障恢復(fù)。
關(guān)于Oracle 11g RAC中INTERMEDIATE Stuck Archiver狀態(tài)的解決方法就分享到這里了,希望以上內(nèi)容可以對大家有一定的幫助,可以學(xué)到更多知識。如果覺得文章不錯,可以把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。