Friday, 18 November 2022

How to delete MGMTDB


Ref : 

  • How to Move/Recreate GI Management Repository (GIMR / MGMTDB) to Different Shared Storage  (Doc ID 1589394.1)
  • 12.2: How to Create GI Management Repository (Doc ID 2246123.1)
    MDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)


 MGMTDB:

. oraenv

+ASM1

as a root user for grid

crsctl stop res ora.crf -init  //node 1

crsctl stop res ora.crf -init  //node2

perfom in both the node:

crsctl modify res ora.crf -attr ENABLED=0 -init

crsctl modify res ora.crf -attr ENABLED=0 -init


srvctl status mgmtdb


as oracle user perform the below

$ORACLE_HOME/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB

$ORACLE_HOME/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB


SUCCESSFULLY DELETED MGMTDB


++++++++++++++++++++++++++++++++++++++++++++++++++++


TO  recreate the MGMTDB in Oracle Database (12.2) required to use a perl script mdbutil.pl 


REF : MDBUtil: GI Management Repository configuration tool (Doc ID 2065175.1)



./mdbutil.pl -h


./mdbutil.pl --addmdb --target=+DATA02


AS A ROOT USER FROM GRID HOME


crsctl modify res ora.crf -attr ENABLED=1 -init


crsctl start res ora.crf -init


REPEAT ON NODE 2


No comments:

Post a Comment

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...