Oracle 11g RAC Votedisk, OCR, and various resource management

Question: Oracle 11g Rac is more difficult to maintain than 10g, and more commands are provided, this section summarizes the Votedisk, OCR, and some commands used for resource maintenance of 11g rac for future reference.

Recommended reading:

Oracle 11g rac ocr and db_unique_name Configuration

Reconfigure and uninstall Oracle 11GR2 Grid Infrastructure

Manage the Votedisk file and check the Votedisk Status $ crsctl query css votedisk add a votedisk $ crsctl add css votedisk + data to another disk group $ crsctl replace votedisk + database if votedisk is damaged, recovery required, you must first start Clusterware to the "exclusive" mode as the root user # crsctl start crs-excl to disable and start the Clusterware service as the root user # crsctl stop crs [-f] ---- f indicates forced # crsctl start crs manage OCR files to manually back up OCR # ocrconfig-manualbackup view the backup OCR file # ocrconfig-showbackup view the content of the OCR backup file # ocrdump-ba Ckupfile backup_file_name restores the OCR backup file # ocrconfig-restore file_name creates an OCR file in the disk group DATABASE as the root user # ocrconfig-add + database deletes excess OCR files # ocrconfig-delete + database migrates the OCR file from the disk group DATA to the disk group DATABASE # ocrconfig-replace + data-replacement + database manages various resources of the RAC cluster to database instances, you can run the following commands to view the status, disable the instance, and start the instance. You can use the-I option to specify one or more instances, or use the-n option to specify the node name $ srvctl status instance-d prod-I prod1, prod2Instance prod1 is running on node ora1Instance prod2 is running on node ora2 $ srvctl stop instance-d prod-I prod1, prod2 $ srvctl start instance-d prod-I prod1, prod2 for databases, you can run the following command to view the database status, shut down the database, and start the database. In fact, when you close the database instance, the database also closes $ srvctl status database-d prodInstance PROD1 is running on node ora1Instance PROD2 is running o N node ora2 $ srvctl stop database-d prod $ srvctl start database-d When shutting down the database, you can specify NORMAL using the-o option after the srvctl command, TRANSACTIONAL, IMMEDIATE, and ABORT. When starting the database, you can also specify one of the keywords "OPEN, MOUNT, and NOMOUNT" through the-o option after the command. $ srvctl start database-d prod-o mount $ srvctl stop database-d prod-o immediate database Listener, you can use the following commands to start and close the listener. You can use the-n option to specify one or more node names $ srvctl status listener $ srvctl stop listener-n ora1 $ srvctl start listener-n ora1, ora2 for ASM instances, you can use the following command to view the status, start and close the instance, and use the-n option to specify the node name, you can also use the-o option to specify OPEN, MOUNT, NOMOUNT, NORMAL, TRANSACTIONAL, IMMEDIATE, and ABORT to start or close an instance. When all ASM instances are closed, the ASM Disk Disable $ srvctl status asm-n ora1, ora2 $ srvctl start asm-n ora1, ora2 $ srvctl stop asm-n ora1, ora2-o abort for ASM disk groups, you can run the following command to view the status, disable, and start a disk group. Use the-n option to specify a node. If Clusterware or the database is accessing files in the ASM disk group, the disk group cannot be closed, use the-f option in the srvctl command to forcibly disable the disk group $ srvctl status diskgroup-g dg1-n ora1, ora2 $ srvctl stop diskgroup-g dg1-n ora1, ora2-f $ srvctl start diskgroup-g dg1-n ora1. for VIP and SCAN, you can also run the srvctl command to check whether the status has been enabled or disabled. When these two types of resources are disabled, such IP addresses will disappear from the operating system. For SCAN, you must use the-I option in the command to specify its number. For VIP, You need to specify its name $ srvctl status scan-I 1 $ srvctl status vip-I ora1-vip through the srvctl AND ITS enable, disable, remove, add clauses, etc, various resources can be activated, prohibited, deleted, or added. When a resource is disabled, it cannot start with the startup of RAC unless it is activated again. When a resource is deleted, it disappears from OCR. When adding a Database Listener, you must specify the port number used by the listener and the installation directory of the database software. $ Srvctl enable listener-l LISTENER-n ora1 $ srvctl disable listener-l LISTENER-n ora1 $ srvctl remove listener-l LISTENER $ srvctl add listener-l LISTENER-p 1521-o/ s01/app/oracle note: the above commands seem simple, but the 11g rac is prone to wrong commands because of the increase in parameters and the limited Sub-division of parameters. We hope that you should be especially careful when maintaining the production database to avoid unnecessary troubles.