| 标题 | Oracle 10g RAC 常用维护命令 |
| 内容 | 所有实例和服务的状态 [oracle@vzwc1 ~]$ srvctl status database -d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 单个实例的状态 [oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc1 Instance zwc1 is running on node vzwc1 [oracle@vzwc1 ~]$ srvctl status instance -d zwc -i zwc2 Instance zwc2 is running on node vzwc2 特定节点上节点应用程序的状态 [oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc1 VIP is running on node: vzwc1 GSD is running on node: vzwc1 Listener is running on node: vzwc1 ONS daemon is running on node: vzwc1 [oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl status nodeapps -n vzwc2 VIP is running on node: vzwc2 GSD is running on node: vzwc2 Listener is running on node: vzwc2 ONS daemon is running on node: vzwc2 ASM 实例的状态 [oracle@vzwc1 ~]$ srvctl status asm -n vzwc1 ASM instance +ASM1 is running on node vzwc1. [oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl status asm -n vzwc2 ASM instance +ASM2 is running on node vzwc2. 显示 RAC 数据库的配置 [oracle@vzwc1 ~]$ srvctl config database -d zwc vzwc1 zwc1 /u01/app/oracle/product/10.2.0/db_1 vzwc2 zwc2 /u01/app/oracle/product/10.2.0/db_1 显示节点应用程序的配置 —(VIP、GSD、ONS、监听) [oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc1 -a -g -s -l VIP exists.: /vzwc1-vip/192.168.1.151/255.255.255.0/eth0 GSD exists. ONS daemon exists. Listener exists. [oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl config nodeapps -n vzwc2 -a -g -s -l VIP exists.: /vzwc2-vip/192.168.1.152/255.255.255.0/eth0 GSD exists. ONS daemon exists. Listener exists. 显示 ASM 实例的配置 [oracle@vzwc1 ~]$ srvctl config asm -n vzwc1 +ASM1 /u01/app/oracle/product/10.2.0/db_1 [oracle@vzwc1 ~]$ [oracle@vzwc1 ~]$ srvctl config asm -n vzwc2 +ASM2 /u01/app/oracle/product/10.2.0/db_1 RAC正在运行的实例 SQL> SELECT 2 inst_id , instance_number inst_no , instance_name inst_name , parallel 6 , status 7 , database_status db_status 8 , active_state state 9 , host_name host 10 FROM gv$instance 11 / INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST ---------- ---------- ---------------- --- ------------ ----------------- --------- ---------- 1 1 zwc1 YES OPEN ACTIVE NORMAL vzwc1 2 2 zwc2 YES OPEN ACTIVE NORMAL vzwc2 磁盘组中的所有数据文件 SQL> select name from v$datafile 2 union 3 select member from v$logfile 4 union 5 select name from v$controlfile 6 union 7 select name from v$tempfile 8 / NAME -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +DATADG/zwc/controlfile/current.260.810684377 +DATADG/zwc/datafile/example.264.810684397 +DATADG/zwc/datafile/sysaux.257.810684333 +DATADG/zwc/datafile/system.256.810684333 +DATADG/zwc/datafile/undotbs1.258.810684333 +DATADG/zwc/datafile/undotbs2.265.810684503 +DATADG/zwc/datafile/users.259.810684333 +DATADG/zwc/onlinelog/group_1.261.810684379 +DATADG/zwc/onlinelog/group_2.262.810684383 +DATADG/zwc/onlinelog/group_3.266.810684557 +DATADG/zwc/onlinelog/group_4.267.810684559 +DATADG/zwc/tempfile/temp.263.810684393 +FLASHDG/zwc/controlfile/current.256.810684377 +FLASHDG/zwc/onlinelog/group_1.257.810684381 +FLASHDG/zwc/onlinelog/group_2.258.810684385 +FLASHDG/zwc/onlinelog/group_3.259.810684559 +FLASHDG/zwc/onlinelog/group_4.260.810684561 OCR存放路径 [oracle@vzwc1 ~]$ ocrcheck Status of Oracle Cluster Registry is as follows : Version : 2 Total space (kbytes) : 1043916 Used space (kbytes) : 3832 Available space (kbytes) : 1040084 ID : 1906841437 Device/File Name : /dev/raw/raw1 Device/File integrity check succeeded Device/File not configured Cluster registry integrity check succeeded VOTEDISK存放路径 [oracle@vzwc1 ~]$ crsctl query css votedisk 0. 0 /dev/raw/raw2 located 1 votedisk(s). clusterware版本 [oracle@vzwc1 ~]$ crsctl query crs activeversion CRS active version on the cluster is [10.2.0.5.0] RAC资源查看 [oracle@vzwc1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE vzwc1 ora....C1.lsnr application ONLINE ONLINE vzwc1 ora.vzwc1.gsd application ONLINE ONLINE vzwc1 ora.vzwc1.ons application ONLINE ONLINE vzwc1 ora.vzwc1.vip application ONLINE ONLINE vzwc1 ora....SM2.asm application ONLINE ONLINE vzwc2 ora....C2.lsnr application ONLINE ONLINE vzwc2 ora.vzwc2.gsd application ONLINE ONLINE vzwc2 ora.vzwc2.ons application ONLINE ONLINE vzwc2 ora.vzwc2.vip application ONLINE ONLINE vzwc2 ora.zwc.db application ONLINE ONLINE vzwc2 ora....c1.inst application ONLINE ONLINE vzwc1 ora....c2.inst application ONLINE ONLINE vzwc2 停止 Oracle 实例，当此实例(和相关服务)关闭后，关闭 ASM 实例。最后，关闭节点应用程序(虚拟 IP、GSD、TNS 监听器和 ONS)。 export ORACLE_SID=zwc1 emctl stop dbconsole srvctl stop instance -d zwc -i zwc1 srvctl stop asm -n vzwc1 srvctl stop nodeapps -n vzwc1 启动节点应用程序(虚拟 IP、GSD、TNS 监听器和 ONS)。当成功启动节点应用程序后，启动 ASM 实例。最后，启动 Oracle 实例(和相关服务)以及EM。 export ORACLE_SID=zwc1 srvctl start nodeapps -n vzwc1 srvctl start asm -n vzwc1 srvctl start instance -d zwc -i zwc1 emctl start dbconsole 启动/停止所有实例及其启用的服务 srvctl start database -d zwc srvctl stop database -d zwc |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。