Oracle 12c中的MGMTDB

最新推荐文章于 2022-12-28 03:08:42 发布

转载最新推荐文章于 2022-12-28 03:08:42 发布 · 286 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/283722

文章标签：

#数据库 #操作系统

本文介绍了Oracle集群中的Grid Infrastructure Management Repository (GIMR)，即Management Database (MGMTDB)。MGMTDB作为多租户数据库存储了集群健康监测、故障诊断等关键信息，并详细解释了其在不同集群配置中的部署方式及常用管理命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MGMTDB系列

1 MGMTDB说明

Every Oracle Standalone Cluster and Oracle Domain Services Cluster contains a Grid Infrastructure Management Repository (GIMR), or the Management Database (MGMTDB).

The Grid Infrastructure Management Repository (GIMR) is a multitenant database with a pluggable database (PDB) for the GIMR of each cluster. The GIMR stores the following information about the cluster:

?Real time performance data the Cluster Health Monitor collects

?Fault, diagnosis, and metric data the Cluster Health Advisor collects

?Cluster-wide events about all resources that Oracle Clusterware collects

?CPU architecture data for Quality of Service Management (QoS)

?Metadata required for Rapid Home Provisioning

The Oracle Standalone Cluster locally hosts the GIMR on an Oracle ASM disk group; this GIMR is a multitenant database with a single pluggable database (PDB).

The global GIMR runs in an Oracle Domain Services Cluster. Oracle Domain Services Cluster locally hosts the GIMR in a separate Oracle ASM disk group. Client clusters, such as Oracle Member Cluster for Database, use the remote GIMR located on the Domain Services Cluster. For two-node or four-node clusters, hosting the GIMR for a cluster on a remote cluster reduces the overhead of running an extra infrastructure repository on a cluster. The GIMR for an Oracle Domain Services Cluster is a multitenant database with one PDB, and additional PDB for each member cluster that is added.

When you configure an Oracle Domain Services Cluster, the installer prompts to configure a separate Oracle ASM disk group for the GIMR, with the default name as MGMT.

常用命令

srvctl stop mgmtdb

srvctl status mgmtdb

srvctl config mgmtdb

srvctl disable mgmtdb

srvctl disable mgmtlsnr

srvctl add mgmtdb

srvctl config mgmtdb

srvctl disable mgmtdb

srvctl enable mgmtdb

srvctl getenv mgmtdb

srvctl modify mgmtdb

srvctl relocate mgmtdb

srvctl remove mgmtdb

srvctl setenv mgmtdb

srvctl start mgmtdb

srvctl status mgmtdb

srvctl stop mgmtdb

srvctl unsetenv mgmtdb

srvctl add mgmtlsnr

srvctl config mgmtlsnr

srvctl disable mgmtlsnr

srvctl enable mgmtlsnr

srvctl getenv mgmtlsnr

srvctl modify mgmtlsnr

srvctl remove mgmtlsnr

srvctl setenv mgmtlsnr

srvctl start mgmtlsnr

srvctl status mgmtlsnr

srvctl stop mgmtlsnr

srvctl unsetenv mgmtlsnr

必须使用grid用户进行登录：

[grid@raclhr-12cR1-N1 ~]$ export ORACLE_SID=-MGMTDB

[grid@raclhr-12cR1-N1 ~]$ sqlplus / as sysdba

MGMTDB数据库的信息：

Database unique name: _mgmtdb

Database name: _mgmtdb

Oracle user: grid

Database instance: -MGMTDB

service_names：_mgmtdb

[root@raclhr-12cR1-N1 ~]# crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE raclhr-12cr1-n1 STABLE