Monday, 6 February 2017

V$ASM_DISK :
MOUNT_STATUS : What are the pre-instance status of the disk relative to group mounts.
Missing :
There is a entry in the Automatic storage management metadata but physical disk not present.
                                                                                            (Or )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.
===============================================================================
HEADER_STATUS: 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
===========================================================================
https://docs.oracle.com/cd/E24693_01/rac.11203/e16794/crsref.htm
CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects ,with which you can perform check, start, and stop operations on the cluster
You can use CRSCTL commands to perform several operations on Oracle Clusterware, such as:
• Starting and stopping Oracle Clusterware resources
• Enabling and disabling Oracle Clusterware daemons
• Checking the health of the cluster
• Managing resources that represent third-party applications
• Integrating Intelligent Platform Management Interface (IPMI) with Oracle Clusterware to provide failure isolation support and to ensure cluster integrity
• Debugging Oracle Clusterware components
Clusterized (Cluster Aware) Commands
Clusterized commands are completely operating system independent; they rely on the OHASD (Oracle High Availability Services daemon). If this daemon is running, then you can perform remote operations, such as the starting, stopping, and checking the status of remote nodes.
You can run clusterized commands on one node to perform operations on another node in the cluster. These are referred to as remote operations. This simplifies administration because, for example, you no longer have to log in to each node to check the status of the Oracle Clusterware on all of your nodes
Clusterized commands include the following:
• crsctl check cluster
• crsctl start cluster
• crsctl stop cluster
crsctl –help to get help
crsctl start –help to get help of specific command.
How to check which group id user belongs to in linux.
[root@blt07768013 ~]# groups ananda3
ananda3 : unix-ananda3-g
crsctl check css to check the status of Cluster Synchronization Services
The crsctl check css command returns output similar to the following:
CRS-4529: Cluster Synchronization Services is online
crsctl check evm command to check the status of the Event Manager
The crsctl check evm command returns output similar to the following:
CRS-4533: Event Manager is online
crsctl get hostname  to get hostname command to retrieve the host name of the local server.
Oracle Clusterware returns the host name of the local server:
$ crsctl get hostname
node2


You can use the following commands only in an Oracle RAC environment:
• crsctl add crs administrator
• crsctl add css votedisk
• crsctl add serverpool
• crsctl check cluster
• crsctl check crs
• crsctl check resource
• crsctl check ctss
• crsctl config crs
• crsctl delete crs administrator
• crsctl delete css votedisk
• crsctl delete node
• crsctl delete serverpool
• crsctl disable crs
• crsctl discover dhcp
• crsctl enable crs
• crsctl get clientid dhcp
• crsctl get css
• crsctl get css ipmiaddr
• crsctl get nodename
• crsctl getperm serverpool
• crsctl lsmodules
• crsctl modify serverpool
• crsctl pin css
• crsctl query crs administrator
• crsctl query crs activeversion
• crsctl query crs releaseversion
• crsctl query crs softwareversion
• crsctl query css ipmiconfig
• crsctl query css ipmidevice
• crsctl query css votedisk
• crsctl query dns
• crsctl release dhcp
• crsctl relocate resource
• crsctl relocate server
• crsctl replace discoverystring
• crsctl replace votedisk
• crsctl request dhcp
• crsctl set css
• crsctl set css ipmiaddr
• crsctl set css ipmiadmin
• crsctl setperm serverpool
• crsctl start cluster
• crsctl start crs
• crsctl start ip
• crsctl start testdns
• crsctl status ip
• crsctl status server
• crsctl status serverpool
• crsctl status testdns
• crsctl stop cluster
• crsctl stop crs
• crsctl stop ip
• crsctl stop testdns
• crsctl unpin css
• crsctl unset css
• crsctl unset css ipmiconfig


crsctl add crs administrator
Syntax
crsctl add crs administrator -u user_name [-f] if you want to provide any user Oracle Clusterware administrative privileges.
Table E-15 crsctl add crs administrator Command Parameters
Parameter Description
-u user_name The name of the user to whom you want to give Oracle Clusterware administrative privileges.
-f Use this option to override the user name validity check.
crsctl add crs administrator -u scott
crsctl add css votedisk path_to_voting_disk [path_to_voting_disk ...] [-purge]
Parameter Description
path_to_voting_disk A fully qualified path to the voting disk you want to add. To add multiple voting disks, separate each path with a space.
-purge Removes all existing voting disks at once. You can replace the existing set of voting files in one operation
Usage Notes
• You should have at least three voting disks, unless you have a storage device, such as a disk array, that provides external redundancy. Oracle recommends that you do not use more than 5 voting disks. The maximum number of voting disks that is supported is 15.
Example
• To add a voting disk to the cluster:
$ crsctl add css votedisk /stor/grid/ -purge
crsctl check cluster [-all | [-n server_name [...]]
You can check the status of the Oracle Clusterware stack on all nodes in the cluster with the -all option or you can specify one or more space-delimited nodes. If you do not specify either option, Oracle Clusterware checks the status of the Oracle Clusterware stack on the local server.
$ crsctl check cluster -all to check the status of the Oracle Clusterware stack on all nodes
*****************************************************************
node1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
*****************************************************************
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

No comments:

Post a Comment