Grid Infrastructure Management Repository (GIMR)
database now mandatory in Oracle GI 18.104.22.168
By Mike Dietrich-Oracle on Aug 22, 2014
During the installation of Oracle Grid Infrastructure 22.214.171.124 you've had the following option to choose YES/NO to install the Grid Infrastructure Management Repository (GIMR) database MGMTDB:
With Oracle Grid Infrastructure 126.96.36.199 this choice has become obsolete and the above screen does not appear anymore. The GIMR database has become mandatory.
What gets stored in the GIMR?
Automatic Installation of Grid Infrastructure Management Repository
The Grid Infrastructure Management Repository is automatically installed with Oracle Grid Infrastructure 12crelease 1 (188.8.131.52). The Grid Infrastructure Management Repository enables such features as Cluster Health Monitor, Oracle Database QoS Management, and Rapid Home Provisioning, and provides a historical metric repository that simplifies viewing of past performance and diagnosis of issues. This capability is fully integrated into Oracle Enterprise Manager Cloud Control for seamless management.
Furthermore what the doc doesn't say explicitly:
- The -MGMTDB has now become a single-tenant deployment having a CDB with one PDB
- This will allow the use of a Utility Cluster that can hold the CDB for a collection of GIMR PDBs
- When you've had already an Oracle 184.108.40.206 GIMR this database will be destroyed and recreated
- Preserving the CHM/OS data can be acchieved with OCULMON to dump it out into node view
- The data files associated with it will be created within the same disk group as OCR or VOTING
- The OUI will get the disk groups for OCR and Voting and chooses the first one - which usually is the first OCR. This may lead to serious space issues. It is tracked internally as Bug:19661882 In a future release there may be an option offered to put in into a separate disk group.
Workaround would be to move the affected OCR to another disk group (use ocrconfig command for it) - see MOS Note:1589394.1
- Some important MOS Notes:
- MOS Note 1568402.1
FAQ: 12c Grid Infrastructure Management Repository, states there's no supported procedure to enable Management Database once the GI stack is configured
- MOS Note: 1921105.1
Managing the Cluster Health Monitor Repository (incl how to resize)
- MOS Note 1589394.1
How to Move GI Management Repository to Different Shared Storage
(shows how to delete and recreate the MGMTDB)
- MOS Note 1631336.1
Cannot delete Management Database (MGMTDB) in 12.1
- MOS Note 1945558.1
_mgmtdb Service Registered with All Local Listeners in a Grid Infrastructure Environment
- Average growth size per day per node is roughly 650-750 MB. E.g. a 4 node cluster would lead at the default retention of 3 days to an approximate size of 5.9-6.8 GB
- Change the retention 220.127.116.11:
$CRS_HOME/bin/oclumon manage -repos changeretentiontime 260000
Change the retention 18.104.22.168:
$CRS_HOME/bin/oclumon manage -repos checkretentiontime 260000
PS: Kudos to Sebastian Solbach who updated me on the things to add (retention, average growth, OUI choosing the first disk group displayed for the MGMTDB) - cheers!