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.
Смотрите видео Oracle Dataguard || How to fix archive lag time span from primary to standby in oracle database 12c онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Oracle Database Solutions 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,909 раз и оно понравилось 51 людям.