You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-64291dbba0849311836952/] or [crayon-64291dbba0852679969077/] Standby -> …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-64291dbba0d78474097732/] Data Guard Recovery Modes …

This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-64291dbba0f95413601751/] or [crayon-64291dbba0f9a883962660/]

Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-64291dbba119a085203974/] After the archives are created, sometimes writing …

If you want to learn What the Redo Log is, you should read the article named “Oracle Redo Log And Archive Log”. I will tell …

What is Redo Apply? Redo Apply performs the task of creating a block-by-block copy of the Primary database. The operations are as follows; The RFS …

I will explan Automatic GAP Resolution in Oracle Data Guard in this article. You may want to read below articles two understand Oracle Data Guard …

I recommend reading article “Oracle Data Guard Architecture” to understand What is Data Guard before reading this article. Redo transport services are responsible for transporting …

What is Archivelog Mode in Oracle? The following operations cannot be performed until archive log mode is enabled. RMAN Online Backup Flashback Database User Managed …

Oracle Data Guard has a simple and easy operation logic. Moves the redo data in the primary database to the Standby database and applies the …