What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …
Read More »
What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …
Read More »We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [crayon-6836efd31595a515339173/] [crayon-6836efd315966780669622/] …
Read More »You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-6836efd316e1c344145554/] or [crayon-6836efd316e22092173813/] Standby -> …
Read More »Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-6836efd31707f573032382/] Data Guard Recovery Modes …
Read More »This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-6836efd3171e8439245655/] or [crayon-6836efd3171eb656301449/]
Read More »Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows. [crayon-6836efd31734f470233231/] After the archives are created, sometimes writing …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »