thestatusofallinstancesandservices$srvctlstatusdatabase-dorclInstanceorcl1isrunningonnodelinux1Instanceorcl2isrunningonnodelinux2thestatusofasingleinstance$srvctlstatusinstance-dorcl-iorcl2Instanceorcl2isrunningonnodelinux2thestatusoftheglobalnamingserviceinthedatabase$srvctsonservicestatusservice-rundorcl-clstororcl2,orcl1特定节点上节点应用程序的状态$srvctlstatusnodeapps-nlinux1VIPisrunningonnode:linux1GSDisrunningonnode:linux1Listenerisrunningonnode:linux1ONSdaemonisrunningonnode:linux1ASM实例的状态$srvctlstatusasm-nlinux1ASMinstance+ASM1isrunningonnodelinux1.列出配置的所有数据库$srvctlconfigdatabaseorcl显示RAC数据库的配置$srvctlconfigdatabase-dorcllinux1orcl1/u01/app/oracle/product/10.2.0/db_1linux2orcl2/u01/app/oracle/product/10.2.0/db_1showsallservicesofthespecifiedclusterdatabase$srvctlconfigservice-dorclorcltestPREF:orcl2orcl1AVAIL:showstheconfigurationofthenodeapplication—(VIP,GSD,ONS,listener)$srvctlconfignodeapps-nlinux1-a-g-s-lVIPexists.:/linux1-vip/192.168.1.200/255.255.255.0/eth0:eth1GSDexists.ONSdaemonexists.Listenerexists.DisplayASMinstanceconfiguration$srvctlconfigasm-nlinux1+ASM1/u01/app/oracle/product/10.2.0/db_1所有正在运行的实例-----------------------------------------------------11orcl1YESOPENACTIVENORMALrac122orcl2YESOPENACTIVENORMALrac2位于磁盘组unionselectmemberfromv$logfileunionselectnamefromv$controlfileunionselectnamefromv$tempfile;NAME中的所有数据文件----------------------------------------------+FLASH_RECOVERY_AREA/orcl/controlfile/current.258.570913191+FLASH_RECOVERY_AREA/orcl/onlinelog/group_1.257.570913201+FLASH_RECOVERY_AREA/orcl/onlinelog/group_2.256.570913211Y_FLASH_REA/orclASH_RECOVER/onlinelog/group_3.259.570918285+FLASH_RECOVERY_AREA/orcl/onlinelog/group_4.260.570918295+ORCL_DATA1/orcl/controlfile/current.259.570913189+ORCL_DATA1/orcl/datafile/example.257.570913311+ORCL_datafile/orndx.270.570920045+ORCL_DATA1/orcl/datafile/sysaux.260.570913287+ORCL_DATA1/orcl/datafile/system.262.570913215+ORCL_DATA1/orcl/datafile/undotbs1.261.570913263+ORCL_DATA1/orcl/datafile/undotbs1.271.570920865+ORCL_DATA1/orcl/datafile/undotbs2.265.570913331+ORCL_DATA1/orcl/datafile/undotbs2.272.570921065+ORCL_DATA1/orcl/datafile/users.264.570913355+ORCL_DATA1/orcl/datafile/users.269.570919829+ORCL_DATA1/orcl/onlinelog/group_1.256.570913195+ORCL_DATA1/orcl/onlinelog/group_2.263.570913205+ORCL_DATA1/orcl/onlinelog/group_3.266.570918279+ORCL_DATA1/orcl/onlinelog/group_4.267.570918289+ORCL_DATA1/orcl/tempfile/temp.258.57091330321rowsselected.属于“ORCL_DATA1”磁盘组的所有ASM磁盘FROMv$asm_diskWHEREgroup_numberIN(selectgroup_numberfromv$asm_diskgroupwherename='ORCL_DATA1');PATH--------------------------------ORCL:VOL1ORCL:VOL2开始/停止RAC集群确保您以oracleUNIX用户身份登录我们将从rac1节点运行所有命令：#su–oracle$hostnameRac1停止OracleRAC10ge环境第一步是停止Oracle实例。当此实例（和相关服务）关闭时，关闭ASM实例。最后，关闭节点应用程序（虚拟IP、GSD、TNS侦听器和ONS）。$exportORACLE_SID=orcl1$emctlstopdbconsole$srvctlstopinstance-dorcl-iorcl1$srvctlstopasm-nrac1$srvctlstopnodeapps–nrac1启动OracleRAC10g环境第一步是启动节点应用程序（虚拟IP、GSD、TNS侦听器和ONS）。成功启动节点应用后，启动ASM实例。最后，启动Oracle实例（和相关服务）和企业管理器数据库控制台。$exportORACLE_SID=orcl1$srvctlstartnodeapps-nrac1$srvctlstartasm-nrac1$srvctlstartinstance-dorcl-iorcl1$emctlstartdbconsole使用SRVCTL启动/停止所有实例启动/停止所有实例及其启用的服务。我只是觉得有意思就把此步骤作为关闭所有实例的一种方法加进来了!$srvctlstartdatabase-dorcl$srvctlstopdatabase-dorcl启停止监听hostb$lsnrctlstartlistener_hostbhostb$lsnrctlstoplistener_hostb备份votningdiskddif=voting_disk_namef=backup_file_nameddif=/dev/rdsk/c4t600C0FF000000000098ADE240330A000d0s4f=votingdisk.bak#ddif=/dev/zerof=/dev/rdsk/c4t600C0FF000000000098ADE240330A000d0s4bs=512count=261120测试#ddif=/dev/rdsk/c4t600C0FF000000000098ADE240330A000d0s4f=/data/backup/rac/vd_backup0420.bak261120+0记录进入261120+0记录调出#cd/data/backup/rac#lsocr0420.bakocrdiskvd_backup0420.bakvotingdisk.bakvotingdisk0420.bak#ddif=/data/backup/rac/vd_backup0420.bakf=/dev/rdsk/c4t600C0FF000000000098ADE240330A000d0s4261120+0记录进入261120+0记录调出BackupOCRdiskViewbackup$ocrconfig-showbackupBackup/data/oracle/crs/bin/ocrconfig-export/data/backup/rac/ocrdisk.bakRestorationneedstostopallnodes,StoptheOracleClusterwaresoftwareonallofthenodes/data/oracle/crs/bin/ocrconfig-importfile_nameautomaticbackuprestore#/data/oracle/crs/bin/ocrconfig-showbackup#/data/oracle/crs/bin/ocrconfig-restore/data/oracle/crs/cdata/db168crs/backup00.ocrhosta$cluvfycompocr-nall//checkocrcheck#ocrcheck配置路径在/var/opt/oracle/ocrconfig_loc文件中如果需要更改路径OCR磁盘配置OCR磁盘空间检查#/data/oracle/crs/bin/ocrcheckStatusofOracleClusterRegistry如下：Version:2Totalspace(kbytes):399752Usedspace(kbytes):3784Availablespace(kbytes):395968ID:148562961Device/FileName:/dev/rdsk/c4t600C0FF000000000098ADE240330A000d0s5Device/FileintegritychecksucceededDevice/FilenotconfiguredClusterregistryintegritychecksucceeded#ASMinstancestatusASMinstance+ASM1isrunningonnodehosta.hosta$特定节点上节点应用程序的状态hosta$srvctlstatusnodeapps-nhostaVIP正在运行的节点：hostaGSD正在运行的节点：hosta侦听器未在节点上运行：hostaONS守护程序在节点上运行：hostahosta$所有实例和服务状态hosta$srvctlstatusdatabase-dcole实例cole1在节点hosta实例上运行cole2在节点hostbhosta上运行$列出所有已配置的数据库hosta$srvctlconfigdatabasecolehosta$显示RAC数据库配置hosta$srvctlconfigdatabase-dcolehostacole1/data/oracle/OracleHomehostbcole2/data/oracle/OracleHomehosta$显示ASM实例的配置hosta$srvctlconfigasm-nhosta+ASM1/data/oracle/OracleHomeshow配置节点应用-(VIP,GSD,ONS,listener)hosta$srvctlconfignodeapps-nhosta-a-g-s-lVIP已经存在。:/a1-vip/10.1.1.9/255.255.0.0/ce0GSD已经存在。ONS守护进程已经存在。侦听器已存在。hosta$集群中所有正在运行的实例----------------------------------------------------11cole1YESOPENACTIVENORMALhosta22cole2YESOPENACTIVENORMALhostb位于磁盘组中的所有数据文件
