1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Difference between physical standby database and Data Guard

Discussion in 'Server Administration and Options' started by vijay_raghavk, Sep 1, 2009.

  1. vijay_raghavk

    vijay_raghavk Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi guys,

    Today I attended one interview. They asked me a difference between the Oracle Physical Standby database and Oracle Dataguard?

    Upto my knowledge Oracle Physical Standby Database is one type of Standby Database can be configured using Oracle Databaguard Feature.

    Can you people calrify me on this.

    Regards,
    Vijayaraghavan K
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Hi, Data guard is nothing but a marketing term for standby resulting from an extra interface to manage the standby database. Now Physical Standby on the other hand is a type of the standby database within a dataguard configuration.
     
  3. vijay_raghavk

    vijay_raghavk Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I searched on internet and able to collect the below small info...

    Standby Database will work on SE. Standby DB will be constantly in recovery mode and apply the redo logs where as Dataguard will work on EE and The standby DB can be in Read/only mode, open mode or in recovery mode.

    I dont know I am right...