Hello @All,
Oracle Version 12.2.0.1
We built 4 ASM disk groups on standby db server. After mount manually, diskgroups dismount again few hours later.
How to fix it?
--alert_+ASM1.log--
My inst 1
2019-12-10T07:06:20.117994+08:00
Dirty detach reconfiguration started (new ddet inc 1, cluster inc 2)
Global Resource Directory partially frozen for dirty detach
dirty detach - domain 2 invalid = TRUE
0 GCS resources traversed, 0 cancelled
2019-12-10T07:06:20.170492+08:00
Dirty Detach Reconfiguration complete (total time 0.1 secs)
2019-12-10T07:06:20.171248+08:00
freeing rdom 2
2019-12-10T07:06:20.181290+08:00
WARNING: dirty detached from lock domain 2
NOTE: CKPT released recovery enqueue for thread 1 group 2 (DATA)
2019-12-10T07:06:20.190315+08:00
NOTE: cache dismounted group 2/0x4D2FC9ED (DATA)
2019-12-10T07:06:20.192626+08:00
SQL> alter diskgroup DATA dismount force /* ASM SERVER:1294977517 */
2019-12-10T07:06:21.197722+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "DATA" is being dismounted
2019-12-10T07:06:21.198226+08:00
ERROR: ORA-15130 in COD recovery for diskgroup 2/0x4d2fc9ed (DATA)
ERROR: ORA-15130 thrown in RBAL for group number 2
2019-12-10T07:06:21.198815+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "DATA" is being dismounted
2019-12-10T07:06:21.199164+08:00
ERROR: ORA-15130 in COD recovery for diskgroup 3/0x865fc9f0 (REDO)
2019-12-10T07:06:21.199270+08:00
NOTE: client +ASM1:+ASM:rac-dr no longer has group 2 (DATA) mounted
ERROR: ORA-15130 thrown in RBAL for group number 3
2019-12-10T07:06:21.199640+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "REDO" is being dismounted
2019-12-10T07:06:21.201937+08:00
NOTE: client DBDR1:DBDR:rac-dr no longer has group 2 (DATA) mounted
2019-12-10T07:06:21.275088+08:00
GMON dismounting group 2 at 544 for pid 34, osid 139056
2019-12-10T07:06:21.275767+08:00
NOTE: Disk DATA01 in mode 0x7f marked for de-assignment
2019-12-10T07:06:21.279484+08:00
SUCCESS: diskgroup DATA was dismounted
2019-12-10T07:06:21.279566+08:00
ERROR: ORA-15130 in COD recovery for diskgroup 3/0x865fc9f0 (REDO)
ERROR: ORA-15130 thrown in RBAL for group number 3
2019-12-10T07:06:21.279899+08:00
SUCCESS: alter diskgroup DATA dismount force /* ASM SERVER:1294977517 */
2019-12-10T07:06:21.280075+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "REDO" is being dismounted
2019-12-10T07:06:21.280572+08:00
SUCCESS: ASM-initiated MANDATORY DISMOUNT of group DATA
2019-12-10T07:06:21.280647+08:00
ERROR: ORA-15130 in COD recovery for diskgroup 3/0x865fc9f0 (REDO)
ERROR: ORA-15130 thrown in RBAL for group number 3
2019-12-10T07:06:21.281136+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "REDO" is being dismounted
2019-12-10T07:06:21.321686+08:00
NOTE: diskgroup resource ora.DATA.dg is offline
2019-12-10T07:06:21.347873+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_ora_82798.trc:
ORA-15078: ASM diskgroup was forcibly dismounted
2019-12-10T07:06:21.429940+08:00
NOTE: client exited [82622]
2019-12-10T07:06:21.792324+08:00
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_rbal_110532.trc:
ORA-15130: diskgroup "REDO" is being dismounted
2019-12-10T07:06:21.799866+08:00
NOTE: client DBDR1:DBDR:rac-dr no longer has group 3 (REDO) mounted
NOTE: cache deleting context for group REDO 3/0x865fc9f0
2019-12-10T07:06:21.892060+08:00
GMON dismounting group 3 at 545 for pid 39, osid 139065
2019-12-10T07:06:21.892788+08:00
NOTE: Disk REDO_0000 in mode 0x7f marked for de-assignment
2019-12-10T07:06:21.896762+08:00
SUCCESS: diskgroup REDO was dismounted
2019-12-10T07:06:21.897676+08:00
SUCCESS: alter diskgroup REDO dismount force /* ASM SERVER:2254424560 */
SUCCESS: ASM-initiated MANDATORY DISMOUNT of group REDO
2019-12-10T07:06:21.942805+08:00