使用工具mdbutil

1.上传至需要执行的node,修改脚本权限，查看MDMTDB运行状态

[root@node1 tmp]# chmod 755 mdbutil.pl
[root@node1 tmp]# ./mdbutil.pl --status
mdbutil.pl version : 1.99
2020-09-27 09:15:00: I Checking CHM status...
2020-09-27 09:15:03: I Listener MGMTLSNR is configured and running on node1
2020-09-27 09:15:07: I Database MGMTDB is configured and running on node1
2020-09-27 09:15:08: I Cluster Health Monitor (CHM) is configured and running
--------------------------------------------------------------------------------
CHM Repository Path = +DATA/_MGMTDB/950581B2857F07D6E0536F040A0AC14B/DATAFILE/sysmgmtdata.278.1021832763
MGMTDB space used on DG +DATA = 42016 Mb
--------------------------------------------------------------------------------
复制

2.关闭数据库实列，切换用户到grid并执行（请确保新的DISKGROUP有足够空间>=步骤1查询出来的空间），

[root@node1 tmp]# su - grid
Last login: Sun Sep 27 09:16:41 CST 2020
[grid@node1 grid_home]$ cd /tmp/
[grid@node1 tmp]$ /tmp/mdbutil.pl --mvmgmtdb --target=+NFRA
mdbutil.pl version : 1.99
Moving MGMTDB, it will be stopped, are you sure (Y/N)? Y
2020-09-27 09:18:48: I Checking for the required paths under +NFRA
2020-09-27 09:18:53: I Creating new path +NFRA/_MGMTDB/PARAMETERFILE
2020-09-27 09:19:03: I Creating new path +NFRA/_MGMTDB/CONTROLFILE
2020-09-27 09:19:12: I Creating new path +NFRA/_MGMTDB/ONLINELOG
2020-09-27 09:19:22: I Creating new path +NFRA/_MGMTDB/DATAFILE
2020-09-27 09:19:30: I Creating new path +NFRA/_MGMTDB/TEMPFILE
2020-09-27 09:19:39: I Creating new path +NFRA/_MGMTDB/DATAFILE/PDB$SEED
2020-09-27 09:19:45: I Creating new path +NFRA/_MGMTDB/DATAFILE/TEMPFILE/PDB$SEED
2020-09-27 09:19:53: I Creating new path +NFRA/_MGMTDB/DATAFILE/node_cluster
2020-09-27 09:19:58: I Creating new path +NFRA/_MGMTDB/TEMPFILE/node_cluster
2020-09-27 09:20:02: I Getting MGMTDB Database files location
2020-09-27 09:20:02: I Getting MGMTDB Temp files location
2020-09-27 09:20:03: I Getting MGMTDB PDB PDB$SEED files location
2020-09-27 09:20:05: I Getting MGMTDB PDB PDB$SEED Temp files location
2020-09-27 09:20:05: I Getting MGMTDB PDB GIMR_DSCREP_10 files location
2020-09-27 09:20:06: I Getting MGMTDB PDB GIMR_DSCREP_10 Temp files location
2020-09-27 09:20:21: I Creating temporary PFILE
2020-09-27 09:20:21: I Creating target SPFILE
2020-09-27 09:20:31: I Stopping the Cluster Health Analysis Resource
2020-09-27 09:20:41: I Stopping mgmtdb
2020-09-27 09:21:25: I Copying MGMTDB DBFiles to +NFRA
2020-09-27 09:24:02: I Copying MGMTDB PDB$SEED DBFiles to +NFRA
2020-09-27 09:24:58: I Copying MGMTDB PDB DBFiles to +NFRA
2020-09-27 09:55:45: I Creating the CTRL File
2020-09-27 09:58:34: I The CTRL File has been created and MGMTDB is now running from +NFRA
2020-09-27 09:58:34: I Setting MGMTDB SPFile location
2020-09-27 09:58:36: I Modifing the init parameter
2020-09-27 09:58:36: I Removing old MGMTDB
2020-09-27 09:58:43: I Changing START_DEPENDENCIES
2020-09-27 09:58:44: I Changing STOP_DEPENDENCIES
2020-09-27 09:58:44: I Restarting MGMTDB using target SPFile
2020-09-27 10:00:49: I Starting the Cluster Health Analysis Resource
2020-09-27 10:00:54: I MGMTDB Successfully moved to +NFRA!
复制

3.查看MGMTDB

[grid@node1 grid_home]$ srvctl config mgmtdb
Database unique name: _mgmtdb
Database name:
Oracle home: <CRS home>
Oracle user: grid
Spfile: +NFRA/_MGMTDB/PARAMETERFILE/spfile.20200927092006
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: GIMR_DSCREP_10
PDB service: GIMR_DSCREP_10
Cluster name: node-cluster
Database instance: -MGMTDB
复制

4.查看CRS信息

[root@node1 tmp]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.NDATA.dg
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.NDATA2.dg
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.NFRA.dg
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.chad
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.net1.network
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
ora.ons
               ONLINE  ONLINE       node1                    STABLE
               ONLINE  ONLINE       node2                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node1                    STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       node1                    169.254.35.234 192.1
                                                             68.4.15,STABLE
ora.asm
      1        ONLINE  ONLINE       node1                    Started,STABLE
      2        ONLINE  ONLINE       node2                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       node1                    STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       node1                    Open,STABLE
ora.node1.vip
      1        ONLINE  ONLINE       node1                    STABLE
ora.node2.vip
      1        ONLINE  ONLINE       node2                    STABLE
ora.qosmserver
      1        ONLINE  ONLINE       node1                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       node1                    STABLE
ora.tar.db
      1        ONLINE  ONLINE       node1                    Open,HOME=/app/12c/d
                                                             b_base/db_home,STABL
                                                             E
      2        ONLINE  ONLINE       node2                    Open,HOME=/app/12c/d
                                                             b_base/db_home,STABL
                                                             E
ora.tar.server_taf.svc
      1        ONLINE  ONLINE       node1                    STABLE
      2        ONLINE  ONLINE       node2                    STABLE
--------------------------------------------------------------------------------
复制

下载 工具下载 https://www.modb.pro/download/13933