{"id":90,"date":"2010-02-21T09:14:00","date_gmt":"2010-02-21T12:14:00","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=90"},"modified":"2010-02-21T09:14:00","modified_gmt":"2010-02-21T12:14:00","slug":"comandos-uteis-oracle-rac-utilitarios-de-manutencao-rac-11g","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=90","title":{"rendered":"Comandos uteis oracle RAC – Utilitarios de manuten\u00e7\u00e3o rac 11g"},"content":{"rendered":"

11g RAC Administration and Maintenance Tasks and Utilities:<\/big><\/big><\/big><\/u><\/span><\/span><\/span><\/a><\/big><\/big><\/big>
<\/big><\/big><\/big><\/u><\/span><\/span>
<\/span><\/span><\/span><\/i><\/span><\/span><\/span>Task List:<\/span><\/span><\/span><\/i><\/span><\/span><\/span>

<\/small><\/small><\/span><\/span><\/small> <\/p>\n

<\/span><\/a><\/span><\/a>Checking CRS Status<\/span><\/a>
Viewing Name Of the Cluster<\/a>
Viewing Nodes Configuration<\/a>
Checking Votedisk Information<\/a>
Checking OCR Disk information<\/a>
Timeout Settings in Cluster<\/a>
ADD\/Remove OCR files<\/a>
ADD\/Remove Votedisk<\/a>
Backing Up OCR<\/a>
Backing Up Votedisk<\/a>
<\/span><\/big><\/span><\/big>Restoring OCR Devices<\/a><\/big>
<\/span><\/big>Restoring Voting Disk Devices<\/a>
<\/big><\/span><\/big>Changing Public IPs as well as Virtual IPs<\/a><\/big>

<\/span><\/big><\/div>\n
\n
<\/span><\/b><\/span><\/b><\/span><\/b>
<\/span><\/b><\/div>\n
<\/a>Checking CRS Status:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n

<\/span><\/big>The below two commands are generally used to check the status of CRS. The first command lists the status of CRS<\/span>
on the local node where as the other command shows the CRS status across all the nodes in Cluster.<\/span><\/p>\n

<\/span><\/big>crsctl check crs<\/span><\/big><\/code> <<-- for the local node<\/code>
<\/code>crsctl check cluster<\/span><\/big><\/code> <<-- <\/code>for remote nodes in the cluster<\/code><\/p>\n

<\/code>[root@node1-pub ~]# crsctl check crs
Cluster Synchronization Services appears healthy
Cluster Ready Services appears healthy
Event Manager appears healthy
[root@node1-pub ~]#<\/code> <\/p>\n

<\/code>Checking Viability of CSS across nodes:<\/span><\/code>
<\/code>
<\/big><\/code><\/big>crsctl check cluster<\/big><\/span><\/code><\/p>\n

<\/span><\/code><\/big>For this command to run, CSS needs to be running on the local node. The “ONLINE” status for remote node says that CSS is running on that node.<\/span>
When CSS is down on the remote node, the status of “OFFLINE” is displayed for that node.<\/span>
<\/big>
<\/code>[root@node1-pub ~]# crsctl check cluster
node1-pub    ONLINE
node2-pub    ONLINE<\/code><\/big> <\/span>
<\/span><\/b><\/span><\/b>
<\/span><\/b> <\/div>\n

<\/a>Viewing Cluster name:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n
<\/span><\/b>
I use below command to get the name of Cluster. You can also dump the ocr and view the name from the dump file.<\/span>

<\/big><\/span><\/b>ocrdump -stdout -keyname SYSTEM | grep -A 1 clustername | grep ORATEXT | awk '{print $3}'<\/big><\/code><\/big>
<\/span><\/b>
[root@node1-pub ~]# ocrdump -stdout -keyname SYSTEM | grep -A 1 clustername | grep ORATEXT | awk '{print $3}'
test-crs<\/span>
[root@node1-pub ~]# <\/p>\n

OR<\/big><\/big><\/p>\n

<\/big>ocrconfig -export \/tmp\/ocr_exp.dat -s online<\/big><\/code>
<\/big>for i in `strings \/tmp\/ocr_exp.dat | grep -A 1 clustername` ; do if [ $i != 'SYSTEM.css.clustername' ]; then echo $i; fi; done<\/big><\/code>
<\/big><\/code><\/span>

[root@node1-pub ~]# ocrconfig -export \/tmp\/ocr_exp.dat -s online
[root@node1-pub ~]# for i in `strings \/tmp\/ocr_exp.dat | grep -A 1 clustername` ; do if [ $i != 'SYSTEM.css.clustername' ]; then echo $i; fi; done
test-crs<\/span>
[root@node1-pub ~]# <\/span><\/big><\/code><\/p>\n

OR<\/p>\n

<\/span><\/big><\/big><\/big><\/code>Oracle creates a directory with the same name as Cluster under the $ORA_CRS_HOME\/cdata. you can get the cluster name from this directory as well.<\/span>

<\/code>[root@node1-pub ~]# ls \/u01\/app\/crs\/cdata
localhost  test-crs<\/span><\/code><\/big>
<\/big>
<\/big><\/code><\/div>\n

<\/a>Viewing No. Of Nodes configured in Cluster:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n
<\/span><\/b>
The below command can be used to find out the number of nodes registered into the cluster.<\/span>
It also displays the node’s Public name, Private name and Virtual name along with their numbers.<\/span><\/p>\n

<\/span><\/span><\/span><\/span>olsnodes -n -p -i<\/big><\/code><\/big><\/p>\n

<\/span><\/span>[root@node1-pub ~]# olsnodes -n -p -i
node1-pub       1       node1-prv       node1-vip
node2-pub       2       node2-prv       node2-vip
<\/code><\/big><\/div>\n

<\/a>Viewing Votedisk Information:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n
<\/span><\/b>
The below command is used to view the no. of Votedisks configured in the Cluster.<\/span><\/p>\n

crsctl query css votedisk<\/code><\/big><\/big>

<\/big>[root@node1-pub ~]# crsctl query css votedisk<\/span>
 0.     0    \/u02\/ocfs2\/vote\/VDFile_0<\/span>
 1.     0    \/u02\/ocfs2\/vote\/VDFile_1<\/span>
 2.     0    \/u02\/ocfs2\/vote\/VDFile_2<\/span>
Located 3 voting disk(s).<\/span>
[root@node1-pub ~]# <\/span>
<\/span>
[root@node1-pub ~]# crsctl check crs<\/span>
Cluster Synchronization Services appears healthy<\/span>
Cluster Ready Services appears healthy<\/span>
Event Manager appears healthy<\/span>
[root@node1-pub ~]# <\/span><\/p>\n

<\/span><\/b><\/div>\n

<\/a><\/span><\/b>Viewing OCR Disk Information:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/span><\/b><\/div>\n
<\/span><\/b>
The below command is used to view the no. of OCR files configured in the Cluster. It also displays the version of OCR<\/span>
as well as storage space information. You can only have 2 OCR files at max.<\/span><\/p>\n

ocrcheck<\/big><\/big><\/code><\/p>\n

[root@node1-pub ~]# ocrcheck<\/span>
Status of Oracle Cluster Registry is as follows :<\/span>
         Version                  :          2<\/span>
         Total space (kbytes)     :     262120<\/span>
         Used space (kbytes)      :       3848<\/span>
         Available space (kbytes) :     258272<\/span>
         ID                       :  744414276<\/span>
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_0<\/span>
                                    Device\/File integrity check succeeded<\/span>
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_1<\/span>
                                    Device\/File integrity check succeeded<\/span>
 <\/span>
         Cluster registry integrity check succeeded<\/span>
 <\/span><\/b><\/div>\n

<\/a>Various Timeout Settings in Cluster:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n
<\/span><\/b>
<\/span><\/span><\/b>Disktimeout: <\/span>
    Disk Latencies in seconds from node-to-Votedisk. Default Value is 200. (Disk IO)<\/span>
Misscount: <\/span>
    Network Latencies in second from node-to-node (Interconnect). Default Value is 60 Sec (Linux) and 30 Sec in Unix platform. (Network IO)<\/span>
    Misscount < Disktimeout<\/span>

NOTE: Do not change them without contacting Oracle Support. This may cause logical corruption to the Data.<\/span><\/p>\n

IF
  (Disk IO Time > Disktimeout) OR (Network <\/code><\/big>IO time > Misscount)<\/span>
THEN<\/span>
   REBOOT NODE<\/span>
ELSE<\/span>
   DO NOT REBOOT<\/span>
END IF;<\/span>
<\/big><\/code>
crsctl get css disktimeout
crsctl get css misscount
crsctl get css  reboottime<\/big><\/code>
<\/big><\/code><\/big>
<\/span><\/b>[<\/span><\/b>root@node1-pub ~]# crsctl get css disktimeout<\/span><\/span>
200<\/span><\/span>
<\/span><\/span>
[root@node1-pub ~]# crsctl get css misscount<\/span><\/span>
Configuration parameter misscount is not defined.<\/span><\/span> <\/span><\/b><<<<< <\/big>This message indicates that the Misscount is not set maually and it is set to it’s <\/span>
Default Value On Linux, it is default to 60 Second. If you want to chang it, you can do that as below. (Not recommended)<\/span>
<\/span><\/b>
[root@node1-pub ~]# crsctl set css misscount 100<\/span><\/span>
Configuration parameter misscount is now set to 100.<\/span><\/span>
[root@node1-pub ~]# crsctl get css misscount<\/span><\/span>
100<\/span><\/span>
<\/span><\/b>
The below command sets the value of misscount back to its Default values:<\/span><\/p>\n

 <\/big><\/code>crsctl unset css misscount<\/span><\/big><\/code> <\/code><\/big>
<\/span><\/b>
[root@node1-pub ~]# crsctl unset css misscount<\/span>
<\/span>
[root@node1-pub ~]# crsctl get css  reboottime<\/span>
3<\/span>
<\/span><\/b><\/span><\/b>
<\/span><\/b><\/div>\n

<\/a>Add\/Remove OCR file in Cluster:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/span><\/b><\/div>\n
\n
<\/span><\/b><\/div>\n


<\/span>Removing OCR File<\/big><\/p>\n

<\/span><\/b>(1) Get the Existing OCR file information by running ocrcheck utility.<\/span><\/p>\n

<\/span><\/b>[root@node1-pub ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3852
         Available space (kbytes) :     258268
         ID                       :  744414276
         Device\/File Name         :<\/span> \/u02\/ocfs2\/ocr\/OCRfile_0 <-- OCR<\/span>
                                    Device\/File integrity check succeeded
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_1 <-- OCR Mirror<\/span>
                               &n
\nbsp;    Device\/File integrity check succeeded<\/p>\n

         Cluster registry integrity check succeeded<\/code><\/p>\n

<\/span><\/b>(2) The First command removes the OCR mirror (\/u02\/ocfs2\/ocr\/OCRfile_1). If you want to remove the OCR<\/span>
      file<\/span> (<\/big>\/u02\/ocfs2\/ocr\/OCRfile_1) <\/span><\/code>run the next command.<\/span>

<\/span><\/b><\/code>ocrconfig -replace ocrmirror<\/big><\/code><\/big>
<\/span>ocrconfig -replace ocr<\/big><\/code><\/big><\/p>\n

<\/span><\/b>[root@node1-pub ~]# ocrconfig -replace ocrmirror
[root@node1-pub ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3852
         Available space (kbytes) :     258268
         ID                       :  744414276
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_0 <<– OCR File
                                    Device\/File integrity check succeeded<\/p>\n

                                    Device\/File not configured  <– OCR Mirror not existed any more<\/p>\n

         Cluster registry integrity check succeeded<\/span><\/p>\n

<\/span><\/b>Adding OCR<\/big>

<\/big>You need to add OCR or OCR Mirror file in a case where you want to move the existing OCR file location to the different Devices.<\/span>
The below command add ths OCR mirror file if OCR file alread exists.<\/span>

(1) Get the Current status of OCR:<\/span><\/p>\n

<\/span><\/b>[root@node1-pub ~]# ocrconfig -replace ocrmirror
[root@node1-pub ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3852
         Available space (kbytes) :     258268
         ID                       :  744414276
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_0 <<– OCR File
                                    Device\/File integrity check succeeded<\/p>\n

                                    Device\/File not configured  <– OCR Mirror does not exist<\/p>\n

         Cluster registry integrity check succeeded
<\/span>
<\/span><\/b>As You can see, I only have one OCR file but not the second file which is OCR Mirror.<\/span>
So, I can add second OCR (OCR Mirror) as below command. <\/span><\/p>\n

ocrconfig -replace ocrmirror <\/big><\/code><\/p>\n

<\/big><\/code><\/big>[root@node1-pub ~]# ocrconfig -replace ocrmirror \/u02\/ocfs2\/ocr\/OCRfile_1
[root@node1-pub ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3852
         Available space (kbytes) :     258268
         ID                       :  744414276
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_0
                                    Device\/File integrity check succeeded
         Device\/File Name         : \/u02\/ocfs2\/ocr\/OCRfile_1
                                    Device\/File integrity check succeeded<\/p>\n

         Cluster registry integrity check succeeded<\/span><\/p>\n

<\/span><\/b>You can have at most 2 OCR devices (OCR itself and its single Mirror) in a cluster. Adding extra Mirror gives you below error message<\/span><\/p>\n

<\/span><\/b>[root@node1-pub ~]# ocrconfig -replace ocrmirror \/u02\/ocfs2\/ocr\/OCRfile_2<\/span>
PROT-21: Invalid parameter<\/span>
[root@node1-pub ~]# <\/span><\/span>

<\/span><\/b><\/div>\n

<\/a>Add\/Remove Votedisk file in Cluster:<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n

<\/span><\/b>Adding Votedisk:<\/big>

<\/big>Get the existing Vote Disks associated into the cluster. To be safe, Bring crs cluster stack down on all the nodes <\/span>
but one on which you are going to add votedisk from.<\/span>

(1) Stop CRS on all the nodes in cluster but one.<\/span>
<\/span><\/b>
[root@node2-pub ~]# crsctl stop crs<\/big><\/span>
<\/span><\/b>
(2) Get the list of Existing Vote Disks<\/span><\/p>\n

<\/span><\/b>crsctl query css votedisk<\/big><\/big><\/code><\/p>\n

[root@node1-pub ~]# crsctl query css votedisk
 0.     0    \/u02\/ocfs2\/vote\/VDFile_0
 1.     0    \/u02\/ocfs2\/vote\/VDFile_1
 2.     0    \/u02\/ocfs2\/vote\/VDFile_2
Located 3 voting disk(s).<\/span><\/p>\n

<\/span><\/b><\/a><\/big>(3) Backup the VoteDisk file<\/span>
<\/span><\/b><\/span>
<\/big>Backup the existing votedisks as below as oracle:<\/span><\/p>\n

<\/span><\/b>dd if=\/u02\/ocfs2\/vote\/VDFile_0 of=$ORACLE_BASE\/bkp\/vd\/VDFile_0<\/big><\/code><\/p>\n

<\/span><\/b>[root@node1-pub ~]# su – oracle
[oracle@node1-pub ~]$ dd if=\/u02\/ocfs2\/vote\/VDFile_0 of=$ORACLE_BASE\/bkp\/vd\/VDFile_0
41024+0 records in
41024+0 records out
[oracle@node1-pub ~]$ <\/span><\/p>\n

<\/span><\/b>(4) Add an Extra Votedisk into the Cluster: <\/span>
<\/span><\/b>
<\/big>    If it is a OCFS, then touch the file as oracle. On raw devices, initialize the raw devices using “dd” command<\/span>
<\/span><\/b>
<\/big><\/code>touch \/u02\/ocfs2\/vote\/VDFile_3 <<-- as oracle
crsctl add css votedisk \/u02\/ocfs2\/vote\/VDFile_3 <<-- as oracle
crsctl query css votedisks<\/big><\/code><\/p>\n

<\/span><\/b>[root@node1-pub ~]# su – oracle
[oracle@node1-pub ~]$ touch \/u02\/ocfs2\/vote\/VDFile_3
[oracle@node1-pub ~]$<\/span> crsctl add css votedisk \/u02\/ocfs2\/vote\/VDFile_3
Now formatting voting disk: \/u02\/ocfs2\/vote\/VDFile_3.
Successful addition of voting disk \/u02\/ocfs2\/vote\/VDFile_3.<\/span><\/p>\n

<\/span><\/b>(5) Confirm that the file has been added successfully:<\/span>

<\/span><\/b>[root@node1-pub ~]# ls -l \/u02\/ocfs2\/vote\/VDFile_3
-rw-r—–  1 oracle oinstall 21004288 Oct  6 16:31 \/u02\/ocfs2\/vote\/VDFile_3
[root@node1-pub ~]# crsctl query css votedisks
Unknown parameter: votedisks
[root@node1-pub ~]# crsctl query css votedisk
 0.     0    \/u02\/ocfs2\/vote\/VDFile_0
 1.     0    \/u02\/ocfs2\/vote\/VDFile_1
 2.     0    \/u02\/ocfs2\/vote\/VDFile_2
 3.     0    \/u02\/ocfs2\/vote\/VDFile_3
Located 4 voting disk(s).
[root@node1-pub ~]#<\/span> <\/p>\n

<\/span><\/b>Removing Votedisk:<\/big>

<\/span><\/b>Removing Votedisk from the cluster is very simple. Tthe below command removes the given votedisk from cluster configuration.<\/span>
<\/big>
<\/span><\/b>crsctl delete css votedisk \/u02\/ocfs2\/vote\/VDFile_3<\/big><\/code><\/p>\n

[root@node1-pub ~]# crsctl delete css votedisk \/u02\/ocfs2\/vote\/VDFile_3
Successful deletion of voting disk \/u02\/ocfs2\/vote\/VDFile_3.
[root@node1-pub ~]# <\/p>\n

[root@node1-pub ~]# crsctl query css votedisk
 0.     0    \/u02\/ocfs2\/vote\/VDFile_0
 1.     0    \/u02\/ocfs2\/vote\/VDFile_1
 2.     0    \/u02\/ocfs2\/vote\/VDFile_2
Located 3 voting disk(s).
[root@node1-pub ~]# <\/span><\/p>\n

<\/span><\/b><\/div>\n

<\/a>Backing Up OCR
<\/span><\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n

<\/span><\/b>Oracle performs physical backup of OCR devices every 4 hours under the default backup direcory $ORA_CRS_HOME\/cdata\/ <\/span>
and then it rolls that forward to Daily, weekly and monthly backup. You can get the backup information by executing below command. <\/span>

<\/code>ocrconfig -showbackup<\/big><\/big><\/code>
<\/code>
<\/big>[root@node1-pub ~]# ocrconfig -showbackup <\/p>\n

node2-pub     2007\/09\/03 17:46:47     \/u01\/app\/crs\/cdata\/test-crs\/backup00.ocr<\/p>\n

node2-pub     2007\/09\/03 13:46:45     \/u01\/app\/crs\/cdata\/test-crs\/backup01.ocr<\/p>\n

node2-pub     2007\/09\/03 09:46:44     \/u01\/app\/crs\/cdata\/test-crs\/backup02.ocr<\/p>\n

node2-pub     2007\/09\/03 01:46:39     \/u01\/app\/crs\/cdata\/test-crs\/day.ocr<\/p>\n

node2-pub     2007\/
\n09\/03 01:46:39     \/u01\/app\/crs\/cdata\/test-crs\/week.ocr
[root@node1-pub ~]# <\/code><\/p>\n

Manually backing up the OCR<\/p>\n

<\/span><\/big>ocrconfig -manualbackup <<--Physical Backup of OCR<\/big><\/big><\/code><\/p>\n

<\/big><\/big><\/code>The above command backs up OCR under the default Backup directory. You can export the contents of the OCR using below command (Logical backup).<\/span><\/p>\n

<\/code><\/big>ocrconfig -export \/tmp\/ocr_exp.dat -s online <<-- Logical Backup of OCR<\/big><\/big><\/code><\/p>\n

<\/big><\/big><\/code><\/div>\n

<\/a>Restoring OCR<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n

<\/big><\/big><\/code>The below command is used to restore the OCR from the physical backup. Shutdown CRS on all nodes.<\/span><\/p>\n

<\/big>ocrconfig -restore <\/big><\/big><\/code>

Locate the avialable Backups<\/span>
<\/big>
<\/code>[root@node1-pub ~]# ocrconfig -showbackup<\/p>\n

node2-pub     2007\/09\/03 17:46:47     \/u01\/app\/crs\/cdata\/test-crs\/backup00.ocr<\/p>\n

node2-pub     2007\/09\/03 13:46:45     \/u01\/app\/crs\/cdata\/test-crs\/backup01.ocr<\/p>\n

node2-pub     2007\/09\/03 09:46:44     \/u01\/app\/crs\/cdata\/test-crs\/backup02.ocr<\/p>\n

node2-pub     2007\/09\/03 01:46:39     \/u01\/app\/crs\/cdata\/test-crs\/day.ocr<\/p>\n

node2-pub     2007\/09\/03 01:46:39     \/u01\/app\/crs\/cdata\/test-crs\/week.ocr<\/p>\n

node1-pub     2007\/10\/07 13:50:41     \/u01\/app\/crs\/cdata\/test-crs\/backup_20071007_135041.ocr<\/code><\/p>\n

<\/big>Perform Restore from previous Backup<\/p>\n

<\/span><\/big>[root@node2-pub ~]# ocrconfig -restore \/u01\/app\/crs\/cdata\/test-crs\/week.ocr
<\/big><\/big><\/code>
<\/big><\/big><\/code>The above command restore the OCR from week old backup.<\/span>
If you have logical backup of OCR (taken using export option), then You can import it with the below command.<\/span>

ocrconfig -import \/tmp\/ocr_exp.dat<\/big><\/big><\/code><\/p>\n

<\/big><\/big><\/code><\/div>\n

<\/a>Restoring Votedisks<\/u><\/i><\/big><\/span><\/span><\/span><\/big><\/div>\n
<\/code><\/p>\n