【原】Oracle RAC维护命令
作者：david_zhang@sh 【转载时请以超链接形式标明文章】
链接：http://www.cnblogs.com/david-zhang-index/archive/2012/07/19/2600139.html
1、查看各节点实例运行状态，grid用户登录
1 node1-> srvctl status database -d kobra 2 Instance kobra1 is running on node node1 3 Instance kobra2 is running on node node2
2、查看单实例的运行状态
1 node1-> srvctl status instance -d kobra -i kobra1 2 Instance kobra1 is running on node node1 3 node1-> srvctl status instance -d kobra -i kobra2 4 Instance kobra2 is running on node node2
3、查看ASM 实例的状态
1 node2-> srvctl status asm -n node1 2 ASM is running on node1 3 node2-> srvctl status asm -n node2 4 ASM is running on node2
4、查看所有数据库名
1 node1-> srvctl config database 2 kobra
5、数据库相关配置信息
1 node1-> srvctl config database -d kobra 2 Database unique name: kobra 3 Database name: kobra 4 Oracle home: /u01/app/oracle/product/11.2.0/db_1 5 Oracle user: oracle 6 Spfile: +DATA/kobra/spfilekobra.ora 7 Domain: 8 Start options: open 9 Stop options: immediate 10 Database role: PRIMARY 11 Management policy: AUTOMATIC 12 Server pools: kobra 13 Database instances: kobra1,kobra2 14 Disk Groups: DATA,FLASH 15 Services: 16 Database is administrator managed
6、查看位于磁盘组中的数据文件
1 SQL> select name from v$datafile; 2 3 NAME 4 -------------------------------------------------------------------------------- 5 +DATA/kobra/datafile/system.256.788824709 6 +DATA/kobra/datafile/sysaux.257.788824757 7 +DATA/kobra/datafile/undotbs1.258.788824775 8 +DATA/kobra/datafile/users.259.788824777 9 +DATA/kobra/datafile/example.264.788827345 10 +DATA/kobra/datafile/undotbs2.265.788843207 11 12 6 rows selected. 13 14 SQL> select member from v$logfile; 15 16 MEMBER 17 -------------------------------------------------------------------------------- 18 +DATA/kobra/onlinelog/group_2.262.788826463 19 +FLASH/kobra/onlinelog/group_2.258.788826471 20 +DATA/kobra/onlinelog/group_1.261.788826445 21 +FLASH/kobra/onlinelog/group_1.257.788826457 22 +DATA/kobra/onlinelog/group_3.266.788847577 23 +FLASH/kobra/onlinelog/group_3.259.788847655 24 +DATA/kobra/onlinelog/group_4.267.788847667 25 +FLASH/kobra/onlinelog/group_4.260.788847721 26 27 8 rows selected. 28 29 SQL> select name from v$controlfile; 30 31 NAME 32 -------------------------------------------------------------------------------- 33 +DATA/kobra/controlfile/current.260.788826287 34 +FLASH/kobra/controlfile/current.256.788826323 35 36 SQL> select name from v$tempfile; 37 38 NAME 39 -------------------------------------------------------------------------------- 40 +DATA/kobra/tempfile/temp.263.788826689
7、查看asm磁盘组名称
1 SQL> select name from v$asm_diskgroup; 2 3 NAME 4 -------------------------------------------------------------------------------- 5 DATA 6 FLASH 7 GRIDDB
8、查看asm磁盘名称
1 SQL> select path from v$asm_disk; 2 3 PATH 4 -------------------------------------------------------------------------------- 5 ORCL:VOL1 6 ORCL:VOL2 7 ORCL:VOL3 8 ORCL:VOL4
