Oracle Dataguard || How to fix archive lag time span from primary to standby in oracle database 12c
How to fix archive lag time span from primary to standby in oracle database 12c.
Oracle dataguard standby system.
For Oracle DBA Interview Questions https://www.unirac.in/qtoa
For Oracle Blog www.unirac.in/blog
Will fix archive lag in standby using parameter ARCHIVE_LAG_TARGET
Solution: - youtube
set archive_lag_target parameter -Dynamic
to disable time based log switching - set to 0 - default
enable set to greater than 0
set to low - value, can be negative impact on performance.
by frequent log switches.
Not applicable in PDB
In RAC,must use same value in every instance.
range 0 or [60-7200]
eg: 30mins = 1800 secs
alter system switch archive_lag_target=600 scope=both;
-
#oracledatabasesolutions #oracledatabase #youtube
-
Note:
The current log was created prior to n seconds ago, and the estimated archival time for the current log is m seconds (proportional to the number of redo blocks used in the current log), where n + m exceeds the value of the ARCHIVE_LAG_TARGET initialization parameter.
Watch video Oracle Dataguard || How to fix archive lag time span from primary to standby in oracle database 12c online without registration, duration hours minute second in high quality. This video was added by user Oracle Database Solutions 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,909 once and liked it 51 people.