Oracle forced log Archiving

Oracle forced log archiving archive_lag_target forced archiving forced switching in the Data Guard environment, if the oracle database archiving frequency is too low, resulting in Data loss in the event of a fault, we can use the archive_lag_target parameter to force log switching and archiving. You can set a time (in seconds) for the archive_lag_target parameter to force the oracle database to switch and archive logs based on the time limit. The default value of this parameter is 0 (disabled ), it is not recommended that the value be greater than 2400 or less than 600 (data loss may occur when a fault occurs for a long time, and too short a time may cause server performance problems ). Set the oracle database to be archived if it is not archived within 30 minutes:

Alter system set archive_lag_target = 1800;

 

Note: The above conditions apply to the max performance mode.