This post validated Oracle note Doc ID 1589394.1.This note outlines the steps to move 12c GIMR (Grid Infrastructure Management Repository) to a different shared storage. In my environment I am using a 2 node system. I am moving the GI Management Repository to Different Shared Storage +FASTDISK. This example is using version 12.1.0.2.
Take a backup:
[oracle-00.qa.alinafe.net:oracle:+ASM2:$~]:/u01/app/12.1.0/grid_1/bin/oclumon dumpnodeview -allnodes -v > GI_MoveBackup
1. Stop and disable ora.crf resource.
On each node, as root user:
[oracle-00.qa.alinafe.net:oracle:+ASM2:$~]:/u01/app/12.1.0/grid_1/bin/crsctl stop res ora.crf -init
[oracle-00.qa.alinafe.net:oracle:+ASM2:$~]:/u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=0 -init
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]:/u01/app/12.1.0/grid_1/bin/crsctl stop res ora.crf -init
#[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]:
/u01/app/12.1.0/grid_1/bin/crsctl modify res ora.crf -attr ENABLED=0 -init
#2. Issue the DBCA command to delete the management database
#As Grid User, locate the node that the Management Database is running by executing:
#[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]:
/u01/app/12.1.0/grid/bin/srvctl status mgmtdb
Database is enabled
Instance -MGMTDB is running on node oracle-test01
[oracle-01.qa.alinafe.net:oracle:ASM2:$~]: /u01/app/12.1.0/grid/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/oracle/cfgtoollogs/dbca/_mgmtdb0.log” for further details.
#3B. For 12.1.0.2 only:
#a. As Grid User on any node execute the following DBCA command with the desired <DG Name>:
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]: /u01/app/12.1.0/grid/bin/dbca -silent -createDatabase -sid -MGMTDB -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -gdbName _mgmtdb -storageType ASM -diskGroupName +FASKDISK -datafileJarLocation /u01/app/12.1.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck
Registering database with Oracle Grid Infrastructure
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
37% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
49% complete
50% complete
55% complete
60% complete
61% complete
64% complete
Completing Database Creation
68% complete
79% complete
89% complete
100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log” for further details.
#As Grid User on any node execute the following DBCA command:
NOTE: The CLUSTER_NAME needs to have any hyphens (“-“) replaced with underscores (“_”)
i.e. some-scan to some_scan
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]/u01/app/12.1.0/grid/bin/dbca -silent -createPluggableDatabase -sourceDB -MGMTDB -pdbName some_scan -createPDBFrom RMANBACKUP -PDBBackUpfile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.dfb -PDBMetadataFile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.xml -createAsClone true
Creating Pluggable Database
4% complete
12% complete
21% complete
38% complete
55% complete
85% complete
Completing Pluggable Database Creation
100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/_mgmtdb/some_scan/_mgmtdb0.log” for further details.
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]: /u01/app/12.1.0/grid/bin/srvctl status MGMTDB
Database is enabled
Instance -MGMTDB is running on node d01
#4. Secure that the Management Database credential:
#As Grid User, confirm the node on which MGMTDB is running by executing.
/u01/app/12.1.0/grid/bin/mgmtca
#5. Enable and start ora.crf resource.
#On each node, as root user:
[oracle-01.qa.alinafe.net:root ~]# /u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=1 -init
#[oracle-01.qa.alinafe.net:root ~]#
/u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=1 -init
[oracle-01.qa.alinafe.net:roo ~]# /u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=1 -init
[oracle-00.qa.alinafe.net:root:+ASM2 ~]# /u01/app/12.1.0/grid/bin/crsctl start res ora.crf -init
CRS-2672: Attempting to start ‘ora.crf’ on ‘d00’
CRS-2676: Start of ‘ora.crf’ on ‘d00’ succeeded
[oracle-00.qa.alinafe.net:root:+ASM2 ~]# /u01/app/12.1.0/grid/bin/crsctl start res ora.crf -init
CRS-2672: Attempting to start ‘ora.crf’ on ‘d01’
CRS-2676: Start of ‘ora.crf’ on ‘d01’ succeeded
#[oracle-00.qa.alinafe.net:oracle:+ASM2:$~]:
/u01/app/12.1.0/grid/bin/srvctl status mgmtdb
Database is enabled
Instance -MGMTDB is running on node oracle-test01
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]: oclumon manage -get reppath
CHM Repository Path = +FASTDISK/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/sysmgmtdata.291.913757899
[oracle-01.qa.alinafe.net:oracle:+ASM2:$~]: srvctl config mgmtdb
Database unique name: _mgmtdb
Database name:
Oracle home: <CRS home>
Oracle user: oracle
Spfile: +FASTDISK/_MGMTDB/PARAMETERFILE/spfile.292.913757517
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: qadc_scan
PDB service: qadc_scan
Cluster name: qadc-scan
Database instance: -MGMTDB
Nice in-depth article but for the googlers Oracle does now provide a much easier way of doing this.
MDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)
LikeLiked by 1 person
How long is taking for oclumon backup to complete, and how large is the backup file?
LikeLike
Per the docs “Use the oclumon dumpnodeview command to view log information from the system monitor service in the form of a node view.”, the size of that dump will depend on your needs, size of clusters. for reference (check the db version) – https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/oclumon-dumpnodeview.html#GUID-E6489AC0-34B3-4B20-8586-CC3B2752413C
LikeLike