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.Column | Datatype | Description |
---|---|---|
GROUP_NUMBER | NUMBER | Number of the disk group containing the disk (foreign key to the V$ASM_DISKGROUP view) |
DISK_NUMBER | NUMBER | Number assigned to the disk within its disk group |
COMPOUND_INDEX | NUMBER | A 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) |
INCARNATION | NUMBER | Incarnation number for the disk |
MOUNT_STATUS | VARCHAR2(7) | Per-instance status of the disk relative to group mounts:
|
HEADER_STATUS | VARCHAR2(12) | Per-instance status of the disk as seen by discovery:
|
MODE_STATUS | VARCHAR2(7) | Global status about which kinds of I/O requests are allowed to the disk:
|
STATE | VARCHAR2(8) | Global state of the disk with respect to the disk group:
|
REDUNDANCY | VARCHAR2(7) | Hardware redundancy of the disk:
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.
|
LIBRARY | VARCHAR2(64) | Name of the library that discovered the disk |
OS_MB | NUMBER | Size of the disk (in megabytes) as reported by the host operating system |
TOTAL_MB | NUMBER | Total capacity of the disk (in megabytes) |
FREE_MB | NUMBER | Unused capacity of the disk (in megabytes) |
NAME | VARCHAR2(30) | Name of the disk |
FAILGROUP | VARCHAR2(30) | Name of the failure group containing the disk |
LABEL | VARCHAR2(31) | Disk label portion of the name returned by discovery |
PATH | VARCHAR2(256) | Operating system pathname portion of the name returned by discovery |
UDID | VARCHAR2(64) | Unique Device ID portion of the name returned by discovery |
PRODUCT | VARCHAR2(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_DATE | DATE | Date and time when the disk was added to the disk group |
MOUNT_DATE | DATE | Date and time when the disk was mounted by the first instance |
REPAIR_TIMER | NUMBER | Seconds remaining until the disk is automatically dropped (0 if not failed) |
READS | NUMBER | Total number of I/O read requests for the disk |
WRITES | NUMBER | Total number of I/O write requests for the disk |
READ_ERRS | NUMBER | Total number of failed I/O read requests for the disk |
WRITE_ERRS | NUMBER | Total number of failed I/O write requests for the disk |
READ_TIME | NUMBER | Total I/O time (in seconds) for read requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false ) |
WRITE_TIME | NUMBER | Total I/O time (in seconds) for write requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false ) |
BYTES_READ | NUMBER | Total number of bytes read from the disk |
BYTES_WRITTEN | NUMBER | Total number of bytes written to the disk |
PREFERRED_READ | VARCHAR2(1) | Status of the preferred read failure group:
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.Column | Datatype | Description |
---|---|---|
GROUP_NUMBER | NUMBER | Cluster-wide number assigned to the disk group (primary key) |
NAME | VARCHAR2(30) | Name of the disk group |
SECTOR_SIZE | NUMBER | Physical block size (in bytes) |
BLOCK_SIZE | NUMBER | Oracle ASM metadata block size (in bytes) |
ALLOCATION_UNIT_SIZE | NUMBER | Size of the allocation unit (in bytes) |
STATE | VARCHAR2(11) | State of the disk group relative to the instance:
|
TYPE | VARCHAR2(6) | Redundancy type for the disk group:
|
TOTAL_MB | NUMBER | Total capacity of the disk group (in megabytes) |
FREE_MB | NUMBER | Unused capacity of the disk group (in megabytes) |
HOT_USED_MB | NUMBER | Number of used megabytes in the hot region |
COLD_USED_MB | NUMBER | Number of used megabytes in the cold region |
REQUIRED_MIRROR_FREE_MB | NUMBER | Amount 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_MB | NUMBER | Amount of free space that can be safely utilized taking mirroring into account and yet be able to restore redundancy after a disk failure |
OFFLINE_DISKS | NUMBER | Number of disks in the disk group that are currently offline |
COMPATIBILITY | VARCHAR2(60) | Minimum software version required for an ASM instance to mount this disk group |
DATABASE_COMPATIBILITY | VARCHAR2(60) | Minimum software version required for a database instance to use files in this disk group |
VOTING_FILES | VARCHAR2(1) | Indicates whether the disk contains voting files (Y ) or not (N ) |
Note:
The GROUP_NUMBER
, TOTAL_MB
, and FREE_MB
columns are only meaningful if the disk group is mounted by the instance. Otherwise, their values will be 0
.
===============================================================
Comments
Post a Comment
Oracle DBA Information