Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
RAC General Administration
Managing the Cluster |
|
| starting | /etc/init.d/init.crs start
crsctl start crs |
| stopping | /etc/init.d/init.crs stop
crsctl stop crs |
| enable/disable at boot time | /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs |
Managing the database configuration with SRVCTL |
|
| start all instances | srvctl start database -d <database> -o <option>
Note: starts listeners if not already running, you can use the -o option to specify startup/shutdown options force |
| stop all instances | srvctl stop database -d <database> -o <option>
Note: the listeners are not stopped, you can use the -o option to specify startup/shutdown options immediate |
| start/stop particular instance | srvctl [start|stop] database -d <database> -i <instance>,<instance> |
| display the registered databases | srvctl config database |
| status | srvctl status database -d <database> srvctl status instance -d <database> -i <instance>,<instance> srvctl status service -d <database> srvctl status nodeapps -n <node> srvctl status asm -n <node> |
| stopping/starting | srvctl stop database -d <database> srvctl stop instance -d <database> -i <instance>,<instance> srvctl stop service -d <database> -s <service>,<service> -i <instance>,<instance> srvctl stop nodeapps -n <node> srvctl stop asm -n <node> srvctl start database -d <database> |
| adding/removing | srvctl add database -d <database> -o <oracle_home> srvctl add instance -d <database> -i <instance> -n <node> srvctl add service -d <database> -s <service> -r <preferred_list> srvctl add nodeapps -n <node> -o <oracle_home> -A <name|ip>/network srvctl add asm -n <node> -i <asm_instance> -o <oracle_home> srvctl remove database -d <database> -o <oracle_home> |
OCR utilities |
|
| log file | $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log |
| checking | ocrcheck
Note: will return the OCR version, total space allocated, space used, free space, location of each device and the result of the integrity check |
| dump contents | ocrdump -backupfile <file>
Note: by default it dumps the contents into a file named OCRDUMP in the current directory |
| export/import | ocrconfig -export <file>
ocrconfig -restore <file> |
| backup/restore | # show backups ocrconfig -showbackup # to change the location of the backup, you can even specify a ASM disk # perform a backup, will use the location specified by the -backuploc location # perform a restore # delete a backup Note: there are many more option so see the ocrconfig man page |
| add/remove/replace | ## add/relocate the ocrmirror file to the specified location ocrconfig -replace ocrmirror ‘/ocfs2/ocr2.dbf’ ## relocate an existing OCR file ## remove the OCR or OCRMirror file |
