N/APosted on - 03/07/2012
How can we find that which server is primary and which server is a standby in dataguard?
How to know if server is in Primary and standby in dataguard(database)?
Manage primary and standby databases by utilizing the SQL command-line interfaces or the Data Guard broker interfaces, that includes a graphical user interface or a command-line interface (DGMGRL) that is integrated in Oracle Enterprise Manager.
A single production database is what a Data Guard configuration consists, also called as the primary database, that works or functions in the primary role. Its the database that is accessed or used by most of your applications. The primary database can be either an Oracle Real Application Clusters database or a single-instance Oracle database.
On the other hand, a standby database is a consistent copy of the primary database. By using a specific backup copy of the primary database, you can create up to nine standby databases and incorporate them in a Data Guard configuration. Once created, Data Guard maintains each standby database by transmitting redo data from the primary database and then applying the redo to the standby database.
In addition, a standby database can be either a logical standby database or physical standby database.