首页 > 其他 > 详细

檢查RAC狀態

时间:2016-05-11 15:15:27      阅读:266      评论:0      收藏:0      [点我收藏+]

1.使用srvctl工具檢查RAC當前配置和狀態

$ srvctl config database -h

Displays the configuration for the database.

Usage: srvctl config database [-d <db_unique_name> [-a] ] [-v]
    -d <db_unique_name>      Unique name for the database
    -a                       Print detailed configuration information
    -v                       Verbose output
    -h                       Print usage

[root@phaws1 ~]# srvctl config database -d phaws
Database unique name: phaws
Database name: phaws
Oracle home: /oracle/product/11.2.0
Oracle user: oracle
Spfile: +SYSDG1/phaws/spfilephaws.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: phaws
Database instances: phaws1,phaws2
Disk Groups: SYSDG1,BACKUPDG,SYSDG2,DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed

Displays the current state of the database.

Usage: srvctl status database -d <db_unique_name> [-f] [-v]
    -d <db_unique_name>      Unique name for the database
    -f                       Include disabled applications
    -v                       Verbose output
    -h                       Print usage

[root@phaws1 ~]# srvctl status database -d phaws
Instance phaws1 is running on node phaws1
Instance phaws2 is running on node phaws2

2.V$ACTIVE_INSTANCES view can also display the current status of the instances

SQL> select INST_NAME from v$active_instances;

INST_NAME
--------------------------------------------------------------------------------
phaws1:phaws1
phaws2:phaws2

檢查RAC狀態

原文:http://www.cnblogs.com/guilingyang/p/5481759.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!