Oracle 11g RAC中INTERMEDIATE Stuck Archiver状态的解决方法

这篇文章给大家介绍Oracle 11g RAC中INTERMEDIATE Stuck Archiver状态的解决方法，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。
新建的库，空跑了几天之后，使用pl/sql工具连接数据库一节点，报没有监听，然后查看监听状态：rac1:/home/oracle@grid> lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 – Production on 02-5月 -2018 09:53:37Copyright (c) 1991, 2013, Oracle免费主机域名. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 2: No such file or directory
二节点监听状态：rac2:/grid/app/11.2.0/network/admin@grid> lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0 – Production on 02-52018 09:48:02Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUS of the LISTENER————————Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0 – ProductionStart Date 11免费主机域名-42018 17:19:45Uptime 20 days 16 hr. 28 min. 17 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /grid/app/11.2.0/network/admin/listener.oraListener Log File /grid/app/grid/diag/tnslsnr/rac2/listener/alert/log.xmlListening 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
然后查看集群状态rac1:/home/oracle@grid> crsctl stat res -t——————————————————————————–Cluster Resources——————————————————————————–省略ora.rac.db1 ONLINE INTERMEDIATE rac1 Stuck Archiver2 ONLINE INTERMEDIATE rac2 Stuck Archiverora.rac1.vip1 ONLINE INTERMEDIATE rac2 FAILED OVERora.rac2.vip1 ONLINE ONLINE rac2
发现现在数据库实例变成了INTERMEDIATEStuckArchiver状态，然后1节点的vip也failed over了
然后继续分析alert日志，发现如下报错信息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.
好像跟归档目录有关系，然后去看归档情况SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 8Next log sequence to archive 10Current log sequence 10SQL> show parameter db_recovery_file_destNAME TYPE VALUE———————————— ———– ——————————db_recovery_file_dest string +ARCHdb_recovery_file_dest_size big integer 5G
发现归档使用ASM存储的+ARCH区域，而且只能使用5G的大小，这也就发现了问题的原因，虽然我们有100g的归档空间，现在只能使用5G，所以归档目录无法写入了
开始解决问题SQL> alter system set db_recovery_file_dest_size=100G;System altered.SQL> show parameter db_recovery_file_destNAME TYPE VALUE———————————— ———– ——————————db_recovery_file_dest string +ARCHdb_recovery_file_dest_size big integer 100G
再看集群状态，发现集群状态恢复正常，然后启动一节点监听rac1:/home/oracle@grid> srvctl start listener -l LISTENER
故障恢复。关于Oracle 11g RAC中INTERMEDIATE Stuck Archiver状态的解决方法就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。

相关推荐: alter table move 和 alter table shrink space的区别是什么

alter table move 和 alter table shrink space的区别是什么，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。 move 和shrink 的共同点1、收缩段2、消…