Thursday, 6 September 2012

Useful 11gR2 Grid (Clusterware commands)

The syntax to start and stop the listener is as follows:
--------------------------------------------------------
srvctl start listener -n nodename
srvctl stop listener -n nodename

Create a disk group with SQL:
----------------------------
CREATE DISKGROUP ACFS NORMAL REDUNDANCY
FAILGROUP ACFS2
DISK 'ORCL:DATA7' SIZE 1953 M ,'ORCL:DATA8' SIZE
2329 M
FAILGROUP ACFS1
DISK 'ORCL:DATA5' SIZE 1953 M ,'ORCL:DATA6' SIZE
1953 M
ATTRIBUTE 'compatible.rdbms' = '11.2.0.0.0',
'compatible.asm' = '11.2.0.0.0',
'compatible.advm' = '11.2.0.0.0' ;

Controlling Oracle Clusterware -
------------------------------

crsctl start crs

crsctl stop crs

crsctl enable crs

crsctl disable crs

To determine the overall health on a specific node: 

crsctl check crs

To check the viability of CSS across nodes :

crsctl check cluster

To determine the location of the Voting disk:

crsctl query css votedisk

To determine the location of the OCR:

cat /etc/oracle/ocr.loc


Checking the integrity of Oracle Clusterware Configuration Files:

grep voting <grid_home>/log/<hostname>/cssd/ocssd.log

or

cluvfy comp ocr -n all -verbose

or

ocrcheck

To add or remove Voting disks (11gR2) for NON-ASM storage -

crsctl delete css votedisk path_to_voting_disk

crsctl add css votedisk path_to_voting_disk

To add Voting disk to ASM -

crsctl replace votedisk +asm_disk_group

To migrate voting disks from non-ASM storage devices to ASM or vice versa, specify the ASM disk group name or path 

to the non-ASM storage device:

crsctl replace votedisk {+asm_disk_group |path_to_voting_disk}

Locating OCR Manual Backups -

ocrconfig -showbackup auto

Default target location for each automatically generated OCR backup file -

<Grid_home>/cdata/<Cluster_name>

Changing the automatic OCR backup location (Best Practice is to store in shared location)-

ocrconfig -backuploc <New_path_name>


Add an OCR location to either ASM or other storage device:

ocrconfig -add +DATA2
ocrconfig -add /dev/sde1

To replace the current OCR location:
 ocrconfig -replace /dev/sde1 -replacement +DATA2

To repair OCR configuration, run this command on the node on which you have stopped Oracle Clusterware:
You cannot perform this operation on a node on which Oracle Clusterware is running.

ocrconfig -repair -add +DATA1

Removing the OCR Location (Do not perform any OCR removal unless there is atleast one other active OCR location

online-

ocrconfig -delete +DATA2
ocrconfig -delete /dev/sde1

Performing Manual OCR backups-

ocrconfig -manualbackup

ocrconfig -showbackup manual

To perform Logical backup -

ocrconfig -export /home/oracle/ocr.backup

To determine the list of interfaces available to the cluster -

oifcfg iflist –p -n

To determine the public and private interfaces that have configured -

oifcfg getif

To determine the VIP hostname, VIP address, VIP subnet mask, VIP interface names -

srvctl config nodeapps -a

No comments:

Post a Comment