Functions of affsert and NOFFRIM parameters in DataGuard

Source: Internet
Author: User
LGWR and affrem, the log writing process synchronously writes REDODATA to the DISK. before writing the DISK, the control is not handed over to the user, and the online logs of the master database may not be used before archiving.

LGWR and affrem, the log writing process synchronously writes redo data to the DISK. before writing the DISK, the control is not handed over to the user, and the online logs of the master database may not be used before archiving.

Purpose: control whether the log Transmission Service asynchronously or synchronously writes log data to the disk.

Affrem: Before the log writing process is in progress, the archive log and the backup database log must be synchronized and written.

Noffrem: the log Writing Process in the master database does not wait until all disk IO is completed.

The default value is noffrem.

Make sure that the following three points are met when you use affrem:

1. Ensure that the data is not lost after the master database fails.

2 can be used locally or remotely

3. The performance of the master database is affected.

The log writing process synchronously writes redo data to the DISK. before writing the DISK, the control is not handed over to the user, in addition, the online logs of the master database may not be used to synchronize the write redo data to the disk by ARCH and affrem ARCn processes before the archiving is completed. The Archiving operation may take a long time, online logs of the master database may be unavailable before logs are archived.

ASYNC and affrem, performance is not affected.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.