Physical Standby "enq: CF - contention & checkpoint completed" waits events after database migration
edited Jun 1, 2016 1:33PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 8 commentsAnswered ✓
Hi guys,
Last Saturday I've migrated a database 11.2.0.3.15 (In Oracle Database Appliance Engineered System) from using ASM disk groups to ASM Cluster File Systems.
Suddenly I see an unexpected behavior, Archived Redo Logs take too much time to be applied in the standby database.
Connection between the servers is good, redo transport is good but not the archived redo log applying.
Also I see the following wait events:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ When I DE ACTIVATE the recovery in Standby Server ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SQL> alter database recover managed standby database cancel; SQL> sta waits WAIT_CLASS EVENT T0 T1 T2 T3 T4 T5 T6 T7 T8 T9 -------------------- ------------------------------ ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- System I/O RFS write 1 System I/O Standby redo I/O 1 1 1 System I/O db file async I/O submit 1 1 1 1 1 1 1 1 1 1 Other MRP inactivation 1 1 1 1 1 1 1 1 1 1 Network SQL*Net message to client 1 1 1 1 1 1 1 1 1 1 Configuration checkpoint completed 5 5 5 5 5
0