Online DBA

  <<Back to Oracle RAC Main Page How to recreate GIMR diskgroup oracle RAC CREATE DISKGROUP GIMR NORMAL REDUNDANCY SITE S1 FAILGROUP GIMR_S1 DISK 'AFD:DISK1' SITE S2 FAILGROUP GIMR_S2 DISK 'AFD:DISK2' ATTRIBUTE 'compatible.asm'='12.1.0.0' , 'compatible.rdbms'='12.1.0.0'; CREATE DISKGROUP GIMR * ERROR at line 1: ORA-15018: diskgroup cannot be created ORA-15030: diskgroup name "GIMR" is in use by another diskgroup Reason:  I dropped the disk group GIMR using sqlplus and tried to create it again with the same name ended with above error message  Solution Though the diskgroup does not exists I dropped it again using asmcmd . Created the diskgroup again it worked  ASMCMD>  dropdg -r -f GIMR;

  <<Back to Oracle RAC Main Page How to re-create oracle RAC -MGMTDB database  Verify Status of -MGMTDB  prompt@node1:~/ [+ASM1]  srvctl status mgmtdb Database is enabled Instance -MGMTDB is running on node node1 prompt@node1:~/ [+ASM1] export ORACLE_SID=-MGMTDB prompt@node1:~/ [-MGMTDB] sqlplus "/as sysdba" Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0 SQL> show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 MGMT_PDB_01                 READ WRITE NO SQL> select comp_id,status from dba_registry; COMP_ID                        STATUS ------------------------------ -------------------------------------------- CATALOG                        VALID CATPROC                        VALID RAC                            OPTION OFF XDB                            VA