檢查RAC狀態

2017-01-12 09:11 出处:360java.com 作者:360java  阅读()
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 Pr

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

分享到:
本文标签: 檢查, 狀態

相关文章

发表评论(共条评论)愿您的每句评论,都能给大家的生活添色彩,带来共鸣,带来思索,带来快乐。

Copyright (C) java学习 360java 360java.com, All Rights Reserved.

苏ICP备16022210号