Site icon IT Tutorial

Oracle Dataguard ( Standby ) Architecture -3


I will continue to tell Oracle Dataguard Architecture in this post.


Oracle Dataguard Architecture 


Read second article before this article.


Oracle Dataguard ( Standby ) Architecture -2



Physical Standby Architecture


1.Maximum Performance: This mode is the default mode for the first installation in Dataguard. In this mode, ASYNC (Asynchronous) Dataguard method is used because the performance of the Primary database is very important.

That is, LGWR process sends commit information to the user without waiting for confirmation of the Redo data sent from the standby database.


2.Maximum Availability: Dataguard provides zero data loss in this mode. The configuration that provides zero data loss is SYNC (Synchronous) Dataguard configuration, as I mentioned above. In this mode, Commit information is not sent without being applied to Standby when the user send a commit for a transaction.

If there is any communication problem between the Primary database and the Standby database, dataguard waits for a certain time. If the communication problem is not solved within this period, LGWR process interrupts the connection with the LNS process and returns commit information to the user. The parameter that the database specifies for a certain period of time is the NET_TIMEOUT parameter. This parameter allows the database to be hanged.


3.Maximum Protection: This mode is like the Maximum Availability feature I described above and uses SYNC Dataguard configuration. There is only one difference between them and the NET_TIMEOUT parameter is not used in this mode, ie the LGWR process will wait for the information from the LNS process that the Redo data has been applied to Standby, If it is not applied then Commit information is not sent to the user.

In this mode, the primary database will consistently wait for information from Standby so dataguard may be hang after a period of time. To prevent this situation, usually create more than one standby database. It is enough that  has been applied to any database. In this method it is important for Primary to use more than one Standby because the possibility of Hang is reduced.


let’s look at the parameters that the Oracle database for Dataguard has to offer. The parameters and functions common to both primary and Standby are as follows.




There are many other parameters that are used for dataguard except for the parameters I described above. Some of them are only used for the Standby database, some of them are only Primary and the important ones and functions are as follows.



I will show you how to install dataguard step by step in the next post.

Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -1





Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Exit mobile version