Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check Data guard usage?

2790985May 6 2015 — edited Aug 27 2015

Hi ,

Could you please provide answer for below two questions?

1) How to check if the Oracle Data Guard is used and working on database servers ?


Oracle -- 11.2.0.4.0

OS       --  Linux 6.6

This is Standalone database.


2) If database role is PHYSICAL STANDBY, does it mean  secondary node of Primary node? Could you please confirm?


SQL> select database_role from v$database

  2  /

DATABASE_ROLE

----------------------------------------------------------------

PHYSICAL STANDBY


Regards,

Bala
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2015
Added on May 6 2015
#data-guard, #performance-availability
27 comments
9,539 views