How to enable CRS and restart CRS on all nodes as root owner

In this blog I am going to talk about RAC administration with CRSCTL command. There are most useful command which we are using in daily routine to enable CRS and restart CRS and manage the cluster services.

Oracle Real Application Clusters

Oracle Real Application Clusters (RAC) allow to run a single standalone Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage. User sessions connecting to Oracle RAC instances can failover and safely replay changes during outages, without any changes to end user applications, hiding the impact of the outages from end users.

A cluster comprises multiple interconnected computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster an Oracle database. Oracle RAC uses Oracle Clusterware for the infrastructure to bind multiple servers so they operate as a single system.

Here we are switching database into Archive log mode in RAC environment. its a simple and straight forward. Please see the below commands.

Switch database into Archive mode (RAC)

SQL> alter system set cluster_database=false scope=spfile sid=’prod1′;

srvctl stop database -d <database>

SQL> startup mount

SQL> alter database archivelog;

SQL> alter system set cluster_database=true scope=spfile sid=’prod1′;

SQL> shutdown;

srvctl start database -d prod

Flashback (RAC)

Make sure that the database is running in archive log mode

Here we are enabling the Flashback log mode in RAC environment. its a simple and straight forward. Please see the below commands.

SQL> archive log list

Setup the flashback

SQL> alter system set cluster_database=false scope=spfile sid=’prod1′;

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=200M scope=spfile;

SQL> alter system set DB_RECOVERY_FILE_DEST=’/u01/flashback’ scope=spfile;

srvctl stop database -p prod1

SQL> startup mount

SQL> alter database flashback on;

SQL> shutdown;

srvctl start database -p prod1

How to shutdown CRS on all nodes and Disable CRS as ROOT user:

# crsctl stop crs

# crsctl disable crs

How to enable CRS and restart CRS on all nodes as ROOT user:

# crsctl enable crs

# crsctl start crs

How to check VIP status is ONLINE / OFFLINE:

$crs_stat or

$crsctl stat res -t ——> 11gr2

How to Check current Version of Clusterware:

$ crsctl query crs activeversion

$ crsctl query crs softwareversion [node_name]

How to Start & Stop CRS and CSS:

$crsctl start crs

$ crsctl stop crs

# /etc/init.d/init.crs start

# /etc/init.d/init.crs stop

# /etc/init.d/init.cssd stop

# /etc/init.d/init.cssd start

How to Enable & Disable CRS:

$ crsctl enable crs

$ crsctl disable crs

# /etc/init.d/init.crs enable

# /etc/init.d/init.crs disable

How to Check current status of CRS:

$ crsctl check crs

$ crsctl check cluster [-node node_name]

How to Check CSS, CRS and EVMD:

$ crsctl check cssd

$ crsctl check crsd

$ crsctl check evmd

How to List the Voting disks currently used by CSS:

$ crsctl check css votedisk

$ crsctl query css votedisk

How to Add and Delete any voting disk:

$ crsctl add css votedisk <PATH>

$ crsctl delete css votedisk <PATH>

How to start clusterware resources:

$ crsctl start resources

$ crsctl stop resources

To Learn more about RAC Command go to RAC ADMINISTRATION

To find more details of RAC click on ORACLE-BASE

Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.
Please comment here for your any query related to above post. You can email me on : oracleocpworld@gmail.com.