How to know if server is in Primary and standby in dataguard(database)?

Asked By madison escobar 0 points N/A Posted on - 03/07/2012

Hi

How can we find that which server is primary and which server is a standby in dataguard?

Thank you

• Status: Open
• Question Views: 1025
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Soriano Xone 0 points N/A #102713

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.

 

About Soriano Xone

Questions
2

Answers
16

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 03/15/2012
• Question Category: Oracle Database