Friday , October 7 2022

Real-Time Apply vs Archive Log Apply Test

In today’s article we will talk about Real-Time Apply vs Archive Log Apply Test.

After setting our Data Guard to Real -Time Apply, we can test as follows whether the changes to be made on the Primary side are instantly visible on the Standby side. In order to query the data on the standby side, we need to activate the Data Guard.

1. We create a table on the Primary side to check that the Real – Time Query is working.

2. We check the table immediately from the standby side.

3. By disabling Real – Time Apply, Real – Time Apply is disabled to see the Apply process as the Archive is created.

4. We create a new table on the primary side.

5. On the standby side, we query the relevant table.

6. Log switch operation is performed and we check whether the archive log is processed on the standby side.

7. If it is seen that the table still does not come after the log switch, we will check whether the log with sequnce is applied on the standby side. [The archives with the first 64 sequence numbers in the query result have been removed to avoid crowding.]

8. When it is seen that it is not applied, a few more log switch operations are performed on the Primary side and the highest sequence# is learned on the Primary side.

9.We query which archives are processed on the standby side. [The archives with the first 64 sequence numbers in the query result have been removed to avoid crowding.]

10. When we see that archive 69 has been processed, we query whether the table has arrived.

 

Onur ARDAHANLI
Author: Onur ARDAHANLI

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *