DataGuard Archives - Page 2 of 4

Command to Check Archivelog Size

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are…

asrblogger July 9, 2024No Comments

DataGuard Oracle

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set (DataGuard Broker Configuration)

The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set, which is causing a conflict or an incorrect configuration in…

asrblogger June 22, 2024No Comments

DataGuard Interview Questions Oracle

Protected: Oracle Data Guard 19c – 100 Interview Questions!!

This content is password protected. To view it please go to the post page and enter the password.

asrblogger June 2, 2024

DataGuard Oracle

Changing Protection Mode in Data Guard !!

In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum Protection, Maximum Availability, or Maximum Performance. The steps to change…

asrblogger April 3, 2024No Comments

DataGuard Oracle

ORA-16855: Transport Lag Has Exceeded Specified Threshold in Data Guard !!

The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby database) has exceeded the specified threshold. Cause: The current apply…

asrblogger February 23, 2024No Comments

DataGuard Oracle

Dataguard Configuration with DG Broker using Active Duplicate in Oracle !!

Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)

asrblogger December 30, 2023No Comments

DataGuard Oracle

Data Guard Protection Mode.

Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby redo logs (of atleast one standby database) before transaction commits…

asrblogger August 4, 2023No Comments

DataGuard Oracle

ORA-16401, ORA-16055 : How to Drop and recreate SRL From Standby Database??

It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is over frequently. So suggestion is to Increase the Size of…

asrblogger July 26, 2023No Comments

DataGuard Oracle

How to use IMPDP with transform=disable_archive_logging:y

DISABLE_ARCHIVE_LOGGING From 12c, during Import operations we can disable archive logging, hence no redo will be generated for the whole impdp job. The ideology behind this feature is, when import…

asrblogger May 21, 2023No Comments

DataGuard Oracle

FAL (Fetch Archive Log) Gap Resolution

Once an Archive Log is received or archived from a Standby Redo Log on the Standby Database, it is registered in the Standby Control file (you can query the Registration…