【原】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

 

posted @   david_zhang@sh  阅读(608)  评论(0)  编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示