1. Whether log_archive_dest_2 is in lgwr,affirm or sync mode ,no matters about the above parameter , by default the protection mode would be max performance.
2. Max Availability will behave like max performance mode when no standby archive destinations available.
3. Max Availability will remain in max availability mode when standby redo logs will not available , in this case archiver process will come into picture.
4. Max protection mode will shutdown automatically if no standby destinations available for log transfer.for this we need atleast 2 log_archive_dest in order to aviod primary instance shutdown;
5. Max protection mode will shutdown if lgwr,async and noaffirm is used.
6. Max availability mode will behave like max performance mode if lgwr,async aand noaffirm is used , also it will use archiver (arch) process instead of lgwr.
7. Max availability mode will use archiver process for atleast gurantee the sync .
8. Max performance will use lgwr incase of lgwr,async,noaffirm instead of arch (in max availability ).
No comments:
Post a Comment