Synchronous Redo Transport Maximum Availability || Datagaurd
Date: Thu, 9 Feb 2023 15:34:14 +0530
Message-ID: <CAO8FHeU2PpDnt33W3ftkdDLzUfn=oTkWiEteCr3V4pup3Y5yYw_at_mail.gmail.com>
Dear Experts ,
Customer has query where he have implemented Max availability as Protection mode by setting LGWR SYNC NOAFFRIM/AFFRIM for one of their critical system to their DR location for minimal data loss , they want to know if there is spike seen in database because of it and they want to go back and disable fast sync /AFFRIM , then do they just need to change DR archive dest location to defer or they too need to downgrade the database mode from max availability to max performance.
Concern here is that they don’t want to use any alter database command in its peak time and considering deferring of DR dest they feel is a safer option , however we are not clear what would be the implication if we simply defer the dest without changing the mode of database from Max Avail. To Max performance
Database version is 19.15 , OS : AIX 7.2
Request you to share some light on the same .
Regards,
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 09 2023 - 11:04:14 CET