IO Bottleneck
=============================
At the and of applying a log (log switch) ==> a Standby database instance performs a complete checkpoint
The database instance will update headers of ALL datafiles comprising the database as well as all copies of the control file
in case there is an IO bottle neck ==> this could result in a slow performance of Managed Recovery in the Standby database
Standby: SQL > select process, block#, blocks from v$managed_standby where process='MRP0'
If you see that Managed Recover is stuck at the block# ==> (blocks - 1)
==> this indicated that the Standby has issues related to this bottle neck
No comments:
Post a Comment