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

最新推荐文章于 2023-04-21 19:08:49 发布

lk_db

最新推荐文章于 2023-04-21 19:08:49 发布

阅读量476

点赞数 1

本文链接：https://blog.csdn.net/lk_db/article/details/92846047

版权

$ 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