I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux.
Log transport parameters are:
log_archive_dest_5 string SERVICE= * * * * **ASYNC NOAFFIRM** valid_for= ... **
Correct me if i'm wrong, so ASYNC noaffirm means the log transfer method is ARCH right? Meaning the archives generated in primary gets copied to standby and then applied there. Right?
The database is primary has been generating too much archives beccause of which my DR lags behind when archives are more. Oracle MOS asks me to create standby redo to resolve the same. My question is that how will standby redo help in reducing the lag since the SRL is used so as not to lose data in case of disaster right?
Also, SRL should be used only when the parameter is LGWR right? Since i have mentioned it as ASYNC NOAFFIRM and there is no standby, the archives are only sent to DR and not redo.
IF I do not have Standby redo, then how does redo gets shipped? Does it gets shipped as archive logs from primary to standby's archive directly and gets applied?
Help me clear out my doubts. Thanks!