crsctl start crs Vs start cluster

CRSCTL utility is used to manage oracle Clusterware.
Starting Clusterware

In 11gR2, you can start the High Availability Service Daemon (OHASD) and Clusterware stack in a single step (A) or start it in a two step process(B).
(A) To start the OHASD & clusterware stack in a single step, use
$ crsctl start crs
Note that you can start components on the local server only with this.
(B) You can do this in two steps; starting OHASD and then starting Clusterware stack. The advantage of using this method is that, if OHASD is running, you can start the clusterware stack on any node from local node.
You can start OHASD by,
$ crsctl start has
then, you can start the clusterware stack by,
$ crsctl start cluster -all
Syntax
crsctl start cluster [-all | -n server_name [...]]
-all Start clusterware on all nodes
-n Start clusterware on particular nodes
If -all or -n is note used, then the clusterware is started only on the local node.
Stopping Clusterware

In 11gR2, you can stop the High Availability Service Daemon (OHASD) and Clusterware stack in a single step (A) or stop it in a two step process(B).
(A) To stop the OHASD & clusterware stack in a single step, use 
$ crsctl stop crs
If any of the process managed by oracle Clusterware is still running after executing it, then the command fails. Use the force option in such cases to terminate them unconditionally.
$ crsctl stop crs –all –f
Note that you can stop components on the local server only with this.
(B) You can stop processes in two steps; stoping OHASD and then stoping Clusterware stack. The advantage of using this method is that, you can stop the clusterware stack on any node from local node.
You can stop the clusterware stack by,
$ crsctl stop cluster -all
Syntax
crsctl stop cluster [-all | -n server_name [...]] [-f]
-all Stop clusterware on all nodes
-n Stop clusterware on particular nodes
-f Use this to stop clusterware resources unconditionally if 'crsctl stop cluster' fails to stop.
If -all or -n is note used, then the clusterware is stopped only on the local node.
Once the clusterware stack is down then you can stop OHASD by,
$ crsctl stop has
The advantage of crsctl stop cluster compared to stop crs command is that it prevent the relocation of 'certain' resources to other servers in the cluster before the Clusterware is stopped on that server.
Status
[root@rac2 ~]# crsctl status server -f
NAME=rac1
STATE=ONLINE
ACTIVE_POOLS=Generic ora.RACDB
STATE_DETAILS=
NAME=rac2
STATE=ONLINE
ACTIVE_POOLS=Generic ora.RACDB
STATE_DETAILS=AUTOSTARTING RESOURCES
[root@rac2 ~]#




==============================================================================

V$ASM_DISK

In an Automatic Storage Management instance, V$ASM_DISK displays one row for every disk discovered by the Automatic Storage Management instance, including disks which are not part of any disk group. In a database instance, V$ASM_DISK only displays rows for disks in disk groups in use by the database instance.
ColumnDatatypeDescription
GROUP_NUMBERNUMBERNumber of the disk group containing the disk (foreign key to the V$ASM_DISKGROUP view)
DISK_NUMBERNUMBERNumber assigned to the disk within its disk group
COMPOUND_INDEXNUMBERA 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bits (for efficient access to the view)
INCARNATIONNUMBERIncarnation number for the disk
MOUNT_STATUSVARCHAR2(7)Per-instance status of the disk relative to group mounts:
  • MISSING - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management disk group but no disk in the storage system was found with the indicated name
  • CLOSED - Disk is present in the storage system but is not being accessed by Automatic Storage Management
  • OPENED - Disk is present in the storage system and is being accessed by Automatic Storage Management. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance.
  • CACHED - Disk is present in the storage system and is part of a disk group being accessed by the Automatic Storage Management instance. This is the normal state for disks in an Automatic Storage Management instance which are part of a mounted disk group.
  • IGNORED - Disk is present in the system but is ignored by ASM because of one of the following:
    • The disk is detected by the system library but is ignored because an ASM library discovered the same disk
    • ASM has determined that the membership claimed by the disk header is no longer valid
  • CLOSING - ASM is in the process of closing this disk
HEADER_STATUSVARCHAR2(12)Per-instance status of the disk as seen by discovery:
  • UNKNOWN - Automatic Storage Management disk header has not been read
  • CANDIDATE - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement
  • INCOMPATIBLE - Version number in the disk header is not compatible with the Automatic Storage Management software version
  • PROVISIONED - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement. The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for Automatic Storage Management.
  • MEMBER - Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option.
  • FORMER - Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a new disk group with the ALTER DISKGROUP statement.
  • CONFLICT - Automatic Storage Management disk was not mounted due to a conflict
  • FOREIGN - Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks.
MODE_STATUSVARCHAR2(7)Global status about which kinds of I/O requests are allowed to the disk:
  • ONLINE - Disk is online and operating normally. Reads and writes are attempted when the disk is mounted. Reads are attempted as part of disk discovery.
  • OFFLINE - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group.
STATEVARCHAR2(8)Global state of the disk with respect to the disk group:
  • UNKNOWN - Automatic Storage Management disk state is not known (typically the disk is not mounted)
  • NORMAL - Disk is online and operating normally
  • ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted
  • DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group.
  • HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped
  • FORCING - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible.
  • DROPPED - Disk has been fully expelled from the disk group
REDUNDANCYVARCHAR2(7)Hardware redundancy of the disk:
  • UNKNOWN
  • UNPROT
  • MIRROR
  • PARITY
Note: This column is valid only if an ASMLIB is present that supports returning hardware redundancy information. This column is not related to the redundancy of the disk group of which the disk is a member.
LIBRARYVARCHAR2(64)Name of the library that discovered the disk
OS_MBNUMBERSize of the disk (in megabytes) as reported by the host operating system
TOTAL_MBNUMBERTotal capacity of the disk (in megabytes)
FREE_MBNUMBERUnused capacity of the disk (in megabytes)
NAMEVARCHAR2(30)Name of the disk
FAILGROUPVARCHAR2(30)Name of the failure group containing the disk
LABELVARCHAR2(31)Disk label portion of the name returned by discovery
PATHVARCHAR2(256)Operating system pathname portion of the name returned by discovery
UDIDVARCHAR2(64)Unique Device ID portion of the name returned by discovery
PRODUCTVARCHAR2(32)Name of the manufacturer and the name of the product. All disks with the same product id will have the same performance and reliability characteristics.
CREATE_DATEDATEDate and time when the disk was added to the disk group
MOUNT_DATEDATEDate and time when the disk was mounted by the first instance
REPAIR_TIMERNUMBERSeconds remaining until the disk is automatically dropped (0 if not failed)
READSNUMBERTotal number of I/O read requests for the disk
WRITESNUMBERTotal number of I/O write requests for the disk
READ_ERRSNUMBERTotal number of failed I/O read requests for the disk
WRITE_ERRSNUMBERTotal number of failed I/O write requests for the disk
READ_TIMENUMBERTotal I/O time (in seconds) for read requests for the disk if the TIMED_STATISTICSinitialization parameter is set to true (0 if set to false)
WRITE_TIMENUMBERTotal I/O time (in seconds) for write requests for the disk if the TIMED_STATISTICSinitialization parameter is set to true (0 if set to false)
BYTES_READNUMBERTotal number of bytes read from the disk
BYTES_WRITTENNUMBERTotal number of bytes written to the disk
PREFERRED_READVARCHAR2(1)Status of the preferred read failure group:
  • U - Disk group has no preferred read failure group
  • Y - Disk is a preferred read disk
  • N - Disk is not a preferred read disk
For a disk group with one or more preferred read failure groups, if the disk is in one of the preferred read failure groups, the value of this column is Y; otherwise it is N.

Note:
The GROUP_NUMBER and DISK_NUMBER columns will only be valid if the disk is part of a disk group which is currently mounted by the instance. Otherwise, GROUP_NUMBER will be 0, and DISK_NUMBER will be a unique value with respect to the other disks that also have a group number of 0.



==============================================================================

V$ASM_DISKGROUP

V$ASM_DISKGROUP displays one row for every ASM disk group discovered by the ASM instance on the node.
ColumnDatatypeDescription
GROUP_NUMBERNUMBERCluster-wide number assigned to the disk group (primary key)
NAMEVARCHAR2(30)Name of the disk group
SECTOR_SIZENUMBERPhysical block size (in bytes)
BLOCK_SIZENUMBEROracle ASM metadata block size (in bytes)
ALLOCATION_UNIT_SIZENUMBERSize of the allocation unit (in bytes)
STATEVARCHAR2(11)State of the disk group relative to the instance:
  • CONNECTED - Disk group is in use by the database instance
  • BROKEN - Database instance lost connectivity to the Oracle ASM instance that mounted the disk group
  • UNKNOWN - Oracle ASM instance has never attempted to mount the disk group
  • DISMOUNTED - Disk group was cleanly dismounted by the Oracle ASM instance following a successful mount
  • MOUNTED - Instance is successfully serving the disk group to its database clients
  • QUIESCING - CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR.
TYPEVARCHAR2(6)Redundancy type for the disk group:
  • EXTERN
  • NORMAL
  • HIGH
TOTAL_MBNUMBERTotal capacity of the disk group (in megabytes)
FREE_MBNUMBERUnused capacity of the disk group (in megabytes)
HOT_USED_MBNUMBERNumber of used megabytes in the hot region
COLD_USED_MBNUMBERNumber of used megabytes in the cold region
REQUIRED_MIRROR_FREE_MBNUMBERAmount of space that is required to be available in a given disk group in order to restore redundancy after one or more disk failures. The amount of space displayed in this column takes mirroring effects into account.
USABLE_FILE_MBNUMBERAmount of free space that can be safely utilized taking mirroring into account and yet be able to restore redundancy after a disk failure
OFFLINE_DISKSNUMBERNumber of disks in the disk group that are currently offline
COMPATIBILITYVARCHAR2(60)Minimum software version required for an ASM instance to mount this disk group
DATABASE_COMPATIBILITYVARCHAR2(60)Minimum software version required for a database instance to use files in this disk group
VOTING_FILESVARCHAR2(1)Indicates whether the disk contains voting files (Y) or not (N)

Note:
The GROUP_NUMBERTOTAL_MB, and FREE_MB columns are only meaningful if the disk group is mounted by the instance. Otherwise, their values will be 0.



===============================================================


Comments