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

Asked By 0 points N/A Posted on -
qa-featured

Hi

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

Thank you

SHARE
Answered By 0 points N/A #102713

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

qa-featured

 

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.
 

Related Questions