Q1. Use crsctl to start, stop the clusterware, disable and enable OHA (5min)
1. Stop Cluster ready service. "crsctl stop" code makes OHA, clusterware disable.
crsctl start crs
crsctl stop crs
2. Check the status of clusterware and OHAs, and start crs.
crsctl check cluster
crsctl check crs
crsctl start crs
Q2. Use srvctl to start and stop database, stop the first instance, disable the second instance, stop the ASM instance of the first node and stop the scan listener (10min)
/* check the list of srvctl stop command */
srvctl stop -h
srvctl stop database -d RACDB
srvctl stop instance -n srv1
srvctl stop instance -n srv2
srvctl stop asm -n srv1
srvctl stop asm -n srv2
srvctl stop scan_listener
Q3. Create a new diskgroup and use it to add a mirror copy of OCR file (5min)
1. [node1, node2] Add a disk to VM machine, and create an ASM disk.
ls /dev/sd*
fdisk /dev/sdg
n
w
oracleasm createdisk NANO /dev/sdg1
oracleasm scandisks
oracleasm listdisks
2. Create a diskgroup.
asmca
3. Using ocrconfig utility, add a new mirror copy of OCR file.
ocrconfig -add +[diskgroup name]
Q4. Get backup location of OCR file, delete current OCR file and restore it from backup (15min)
/* YOU HAVE TO ALL DISKGROUPS MAKE ATTRIBUTE "COMPATIABLE.ASM > 11.2.0.0.0". THEN YOU CAN SUCCESSFULLY REPLACE OCR FILE. */
1. backup OCR file
ocrconfig -manualbackup
/* check the backuplist of ocr file */
ocrconfig -showbackup
2. delete current OCR file, and stop crs.
/* delete ocr.loc, but I just change change name of the file. */
cd /u01/app/19c/grid_base/crsdata/srv1/ocr
ls
mv day.ocr backup00.ocr backup01.ocr
crsctl stop crs
3. restore it from backup
/* open Oracle Clusterware with exclusive mode */
crsctl start crs -excl -nocrs
ocrconfig -showbackup [-local]
ocrconfig -restore +CRS:/srv/OCRBACKUP/backup00.ocr.265.1144955181
crsctl stop crs
crsctl start crs
Q5. Remove mirror copy of OCR file, move the OCR file from main storage to the new diskgroup (10min)
1. remove mirror copy of OCR file of diskgroup NANO.
ocrconfig -delete +NANO
2. replace OCR file from main storage to the new diskgroup.
/* You must have at least two OCR devices to use this command. If you do not have at least two OCR devices, then you must run the ocrconfig -add command to add a new OCR device followed by the "ocrconfig -delete" command to delete the OCR device you want to replace. */
ocrconfig -replace +OCR -replacement +NANO
Q6. Change default location of auto backup of OCR file (5min)
1. Change default location of backup directory.
ocrconfig -backuploc +<ASM Group you want to change>
ocrconfig -manualbackup
ocrconfig -showbackup
Q7. Run the Cluster Verfify Utility before and post databaes installation, and check connectivity, user, permission, ASM, OCR and Votedisk verifications (10min)
cluvfy stage -pre crsinst -n all -verbose
cluvfy stage -post crsinst -n all -verbose
References
