Monday, August 08, 2011

How to find the Master node in RAC

 

The command is oracle@DB_Node2:/home/oracle $ ocrconfig –showbackup
Since, the OCR Automatic backups are taken only by master node. We can verify with following command.


DB_Node1     2011/08/07 22:50:25     /app/crs/product/11g/cdata/PRDDB_cluster/backup00.ocr
DB_Node1     2011/08/07 18:50:24     /app/crs/product/11g/cdata/PRDDB_cluster/backup01.ocr
DB_Node1     2011/08/07 14:50:24     /app/crs/product/11g/cdata/PRDDB_cluster/backup02.ocr
DB_Node1     2011/08/06 06:50:16     /app/crs/product/11g/cdata/PRDDB_cluster/day.ocr
DB_Node1     2011/07/26 06:48:45     /app/crs/product/11g/cdata/PRDDB_cluster/week.ocr

Here the Master node is DB_Node1

1 comment:

Yousuf said...

[oracle@aproodbrac100 ~]$ ocrconfig -showbackup

aproodbrac100 2012/12/10 12:11:04 /product/app/11.2.0/grid/cdata/cproodb

aproodbrac100 2012/12/10 08:11:03 /product/app/11.2.0/grid/cdata/cproodb

bproodbrac100 2012/12/10 02:15:55 /product/app/11.2.0/grid/cdata/cproodb

bproodbrac100 2012/12/10 02:15:55 /product/app/11.2.0/grid/cdata/cproodb

aproodbrac100 2012/12/02 07:53:05 /product/app/11.2.0/grid/cdata/cproodb

bproodbrac100 2012/12/10 01:51:29 /product/app/11.2.0/grid/cdata/cproodb


can you please specify which is my primary/master node among the two?