Oracle 12c RAC: MGMTDB

  12c RAC 引入了 Grid 管理資料庫，Grid Infrastructure Management Repository (GIMR) database --MGMTDB。
  監控執行狀態：
        grid1 {/home/oracle}: srvctl status mgmtdb
           Database is enabled
        Instance -MGMTDB is running on node icbcvm1
  登入到 mgmtdb 中

export ORACLE_SID=_MGMTDB
SQL> select name,cdb from v$database;
 
NAME      CDB
--------- ---
_MGMTDB   YES
 
SQL> select dbid,name,open_mode from v$pdbs;
 
no rows selected
(沒有 pdb)

  由於管理員對 mgmtdb 不熟悉，為了保持和之前11g 服務一致，可以將這個 DB 刪除。使用 DBCA

grid1 {/home/oracle}: $GRID_HOME/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/app/cfgtoollogs/dbca/_mgmtdb.log" for further details.
grid1 {/home/oracle}:

不過還是建議 DBA 對與這個 Database 進行保留。