Wednesday, October 28, 2009

11g CRS commands

My 11g CRS commands reference

$crsctl check cluster

$crsctl stop cluster

$crsctl start cluster

$crsctl stop crs -wait - I like like this command

$crsctl enable crs

$crsctl disable crs

$crsctl check crs

$crsctl check crsd

$crsctl check evmd

$crsctl check cssd

$crsctl query css votedisk

$crsctl add css votedisk

$crsctl delete css votedisk

Patches with 11g

With 11g you can query the cluster ware patch details. This will make patching easier for dba.If you have more than 2 nodes then this will really help :).

$crsctl query crs softwareversion (Node1 or Node8).

Active version:

Active version is the lowest version in your environment. This will help if you have more than 3-4 nodes.

$crsctl query crs activeversion:

Oracle 11g ASM R2 new features

Today I was reading the new features document on Oracle 11g R2. Oracle has introduce lot of cool features like asmcmd enhasments,diskgroup parameters.This week I am planning to test these parameters on my test box.Looks like DBA life with oracle 11g will be very easy and hope it will not have any bugs.

Disk Group parameters:

-au_size Not its possible to set the au size to 1M,2M,4M,8M...64M.

-access control Wow....access control at the ASM level

-compatible.rdbms

-compatible.asm


Force Disk Group Drop:

DROP DISKGROUP DATA01 FORCE INCLUDING CONTENTS;

With 10g we have to format the disks sometimes.

ASMCMD commands:

-Now we can stop, start the asm instance through ASMCMD.

-Disk group creation from ASMCMD