c -MGMTDB_rbal_10460.trm cdmp_20141208110555 -MGMTDB_dbrm_7469.trc -MGMTDB_m000_10202.trm -MGMTDB_mark_10484.trc -MGMTDB_ora_3770.trm -MGMTDB_rbal_4782.trc

MGMT DB 的日志和trace 都在这个里。

3 MGMTDB是带一个PDB的CDB数据库

前面说了，MGMTDB 是一个实例，实际上，MGMTDB是带一个PDB的CDB库，我们可以使用GI的命令直接去操作MGMTDB 对应的PDB。

--查看MGMTDB当前节点：

[grid@rac2 /]$ oclumon manage -get master

Master = rac1



--查看状态：

[grid@rac2 /]$ srvctl status mgmtdb

Database is enabled

Instance -MGMTDB is running on node rac2



--查看配置信息：

[grid@rac2 /]$ srvctl config mgmtdb

Database unique name: _mgmtdb

Database name:

Oracle home: /u01/gridsoft/12.1.0

Oracle user: grid

Spfile:+OCR_VOTING/_mgmtdb/spfile-MGMTDB.ora

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Database instance: -MGMTDB

Type: Management



--连接MGMTDB实例

[grid@rac2 /]$ export ORACLE_SID=-MGMTDB

[grid@rac2 /]$ sqlplus / as sysdba



SQL*Plus: Release 12.1.0.1.0 Production onMon Dec 8 15:24:37 2014



Copyright (c) 1982, 2013, Oracle. All rights reserved.





Connected to:

Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit Production

With the Partitioning, Automatic StorageManagement and Advanced Analytics options



SQL> select file_name fromdba_data_files union select member file_name from V$logfile;



FILE_NAME

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

+OCR_VOTING/_MGMTDB/DATAFILE/sysaux.258.854939615

+OCR_VOTING/_MGMTDB/DATAFILE/sysgridhomedata.261.854939891

+OCR_VOTING/_MGMTDB/DATAFILE/sysmgmtdata.260.854939737

+OCR_VOTING/_MGMTDB/DATAFILE/system.259.854939661

+OCR_VOTING/_MGMTDB/DATAFILE/undotbs1.257.854939605

+OCR_VOTING/_MGMTDB/ONLINELOG/group_1.263.854940051

+OCR_VOTING/_MGMTDB/ONLINELOG/group_2.264.854940053

+OCR_VOTING/_MGMTDB/ONLINELOG/group_3.265.854940057



8 rows selected.

这里查询的是MGMTDB的路径，也可以直接用如下命令查询：

[grid@rac2 /]$ oclumon manage -get reppath

CHM Repository Path =+OCR_VOTING/_MGMTDB/DATAFILE/sysmgmtdata.260.854939737

[grid@rac2 /]$





--查询MGMTDB用户：

SQL> select username,account_status fromdba_users where username like 'CH%';



USERNAME ACCOUNT_STATUS

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

CHM OPEN

CHA OPEN

Oracle 12cRAC MGMTDB说明(二)

3 MGMTDB是带一个PDB的CDB数据库

Oracle 12cRAC MGMTDB说明(二)