Cluster Resource Activity Log Oracle RAC 12c

Cluster Resource Activity Log Oracle RAC 12c: Explained

What is Cluster Resource Activity Log?

Oracle Clusterware stores logs about resource failures in the cluster resource activity log, which is located in the Grid Infrastructure Management Repository.

Where to Find Cluster Resource Activity Log?

Cluster Resource Activity Log is stored in Grid Infrastructure Management Repository Database

Managing the Cluster Resource Activity Log

How to Query the cluster resource activity logs ?

$crsctl query calog

2017-06-17 17:15:57.133000 : Starting Oracle Cluster Ready Services-managed resources on server 'node1' : 149771255713213096/0/1 :
2017-06-17 17:15:57.143000 : Server 'node1' has been assigned to pool 'Free'. : 149771255713213096/0/2 :
2017-06-17 17:17:08.580000 : Resource 'ora.net1.network' has been registered. : 149771255713213096/152/1 :
2017-06-17 17:17:16.867000 : Resource 'ora.node1.vip' has been registered. : 149771255713213096/186/1 :
.
.
.
2017-06-17 18:29:13.580000 : detected unplanned state change of resource 'ora.scan2.vip' from state 'ONLINE' to 'OFFLINE' : 149771255713213096/3861/1 :
2017-06-17 18:29:13.616000 : Attempting to clean 'ora.scan2.vip' on 'node1' : 149771255713213096/3861/2 :
2017-06-17 18:29:13.671000 : detected unplanned state change of resource 'ora.LISTENER_SCAN2.lsnr' from state 'ONLINE' to 'OFFLINE' : 149771255713213096/3864/1 :2017-06-17 18:29:13.848000 : Start of 'ora.net1.network' on 'node1' failed : 149771255713213096/3860/3 :
2017-06-17 18:29:13.848000 : Attempting to clean 'ora.net1.network' on 'node1' : 149771255713213096/3860/4 :
2017-06-17 18:29:13.859000 : Clean of 'ora.scan2.vip' on 'node1' succeeded : 149771255713213096/3861/3 :
2017-06-17 18:29:13.860000 : Attempting to start 'ora.scan2.vip' on 'node2' : 149771255713213096/3861/4 :
2017-06-17 18:29:13.882000 : detected unplanned state change of resource 'ora.scan3.vip' from state 'ONLINE' to 'OFFLINE' : 149771255713213096/3866/1 :

How much space is allocated for Cluster Resource Activity Log?

$ crsctl get calog maxsize

CRS-6760: The maximum size of the Oracle cluster activity log is 1024 MB.

What is Retention Time for Resource Activity Log ?

$ crsctl get calog retentiontime

CRS-6781: The retention time of the cluster activity log is 73 hours.

Can We Change the Size and Retention time ?

yes you can Change it as follows

$crsctl set calog maxsize 2048

$ crsctl get calog maxsize

CRS-6760: The maximum size of the Oracle cluster activity log is 2048 MB.

Note if you try to reduce the MaxSize you must use -f Option

$ crsctl set calog maxsize 1024

CRS-40020: The operation will delete all entries in cluster activity log. Rerun with '-f' option.
CRS-4000: Command Set failed, or completed with Errors.

$ crsctl set calog maxsize 1024 -f
$ crsctl get calog maxsize

CRS-6760: The maximum size of the Oracle cluster activity log is 1024 MB.

Changing the Retention Time

$ crsctl set calog retentiontime 80
$ crsctl get calog retentiontime

CRS-6781: The retention time of the cluster activity log is 80 hours.

Note if you try to reduce the Retention Time you must use -f Option

$ crsctl set calog retentiontime 70

CRS-40020: The operation will delete all entries in cluster activity log. Rerun with '-f' option.
CRS-4000: Command Set failed, or completed with errors.

$ crsctl set calog retentiontime 70 -f
$ crsctl get calog retentiontime

CRS-6781: The retention time of the cluster activity log is 70 hours.

I hope you have enjoyed the post. If you like my work please leave your Comments/ Suggestions in the Comment Section.

If you have any questions please leave in comment Section I will try to answer ASAP