Shulou(Shulou.com)05/31 Report--

This article introduces you to Oracle 11g RAC INTERMEDIATE Stuck Archiver state solution, the content is very detailed, interested friends can refer to, I hope to help you.

After a few days of empty running, use pl/sql tool to connect a node in the database, report no listening, and then check the listening status:

rac1:/home/oracle@grid> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-May-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

Node 2 Monitoring Status:

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

Then check the cluster status

rac1:/home/oracle@grid> crsctl stat res -t

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

omitted

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

Found that the database instance now becomes INTERMEDIATE Stuck Archiver state, and then the vip of node 1 also failed over

Then continue to analyze the alert log and find the following error message

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.

It seems to have something to do with the archive directory, and then go to see the archive situation

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

Found that the archive uses ASM storage +ARCH area, and can only use 5G size, which also found the cause of the problem, although we have 100g of archive space, now only 5G, so the archive directory can not be written

Start solving problems.

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

Then check the cluster status and find that the cluster status is back to normal, and then start a node to listen

rac1:/home/oracle@grid> srvctl start listener -l LISTENER

Failure recovery.

About Oracle 11g RAC INTERMEDIATE Stuck Archiver state solution to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.