RAC中ora.hisdg.db中hisdg指的是db_unique_name

最新推荐文章于 2024-12-05 18:33:00 发布

原创最新推荐文章于 2024-12-05 18:33:00 发布 · 521 阅读

CC 4.0 BY-SA版权

博客展示了使用crsctl stat res -t命令查询Oracle资源状态，包括本地资源和集群资源的状态信息。还展示了使用sqlplus连接到Oracle数据库后，通过show parameter命令查看数据库实例、名称、服务等相关参数的操作。

$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS

--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.DATA.dg
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.FRA.dg
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.LISTENER.lsnr
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.REDO.dg
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.asm
ONLINE ONLINE oracle01 Started

ONLINE ONLINE oracle02 Started

ora.gsd
OFFLINE OFFLINE oracle01

OFFLINE OFFLINE oracle02

ora.net1.network
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.ons
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

ora.registry.acfs
ONLINE ONLINE oracle01

ONLINE ONLINE oracle02

--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oracle02

ora.cvu
1 ONLINE ONLINE oracle02

ora.hisdg.db
1 ONLINE ONLINE oracle01 Open

2 ONLINE ONLINE oracle02 Open

ora.oc4j
1 ONLINE ONLINE oracle02

ora.oracle01.vip
1 ONLINE ONLINE oracle01

ora.oracle02.vip
1 ONLINE ONLINE oracle02

ora.scan1.vip
1 ONLINE ONLINE oracle02

$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 19 20:13:00 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,Data Mining and Real Application Testing options

SQL> show parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string orcl2
instance_number integer 2
instance_type string RDBMS
instant_restore boolean FALSE
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2

SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string orcl

SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl, sdxrds

SQL> show parameter db_uni
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string hisdg