oracel怎么查询是否打开oracle rac
发布网友
发布时间：2022-04-13 16:52
共1个回答
热心网友
时间：2022-04-13 18:21
[oracle@rhel1 ~]$ su - grid
Password:
[grid@rhel1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rhel1
ora....ER.lsnr ora....er.type ONLINE ONLINE rhel1
ora....N1.lsnr ora....er.type ONLINE ONLINE rhel2
ora....N2.lsnr ora....er.type ONLINE ONLINE rhel1
ora....N3.lsnr ora....er.type ONLINE ONLINE rhel1
ora.VOTE.dg ora....up.type ONLINE ONLINE rhel1
ora.asm ora.asm.type ONLINE ONLINE rhel1
ora.cvu ora.cvu.type ONLINE ONLINE rhel1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rhel1
ora.oc4j ora.oc4j.type ONLINE ONLINE rhel1
ora.ons ora.ons.type ONLINE ONLINE rhel1
ora....ry.acfs ora....fs.type ONLINE ONLINE rhel1
ora....SM1.asm application ONLINE ONLINE rhel1
ora....L1.lsnr application ONLINE ONLINE rhel1
ora.rhel1.gsd application OFFLINE OFFLINE
ora.rhel1.ons application ONLINE ONLINE rhel1
ora.rhel1.vip ora....t1.type ONLINE ONLINE rhel1
ora....SM2.asm application ONLINE ONLINE rhel2
ora....L2.lsnr application ONLINE ONLINE rhel2
ora.rhel2.gsd application OFFLINE OFFLINE
ora.rhel2.ons application ONLINE ONLINE rhel2
ora.rhel2.vip ora....t1.type ONLINE ONLINE rhel2
ora.scan1.vip ora....ip.type ONLINE ONLINE rhel2
ora.scan2.vip ora....ip.type ONLINE ONLINE rhel1
ora.scan3.vip ora....ip.type ONLINE ONLINE rhel1
ora.testrac.db ora....se.type ONLINE ONLINE rhel1
查看rac 组件的状态
数据库里面查询 一个库 两(多)个实例 rac已开启
SQL> select inst_id,dbid,name,open_mode from gv$database;
INST_ID DBID NAME OPEN_MODE
---------- ---------- ---------- ----------
2 238688887 TESTRAC READ WRITE
1 238688887 TESTRAC READ WRITE
查看数据库参数
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
cluster_database 是true 证明也是rac模式
