Skip to Content
0
Jun 10, 2013 at 06:51 AM

Data Guard Configuration status - Primary and Standby

2193 Views

Hi,

In the production environment log files are generated and ships to Standby server.

I wants to know whether it is configured with data guard or it is using shell scripts to transferring logs and applying logs

How can I can determine, if dataguard is configured on a database

1. How can i find whether data guard is configured or not.?

2. In which server, should i check ? (Primary DB or Standby DB)

3. Server , DG is configuring? (In Primary or In Standby)

These are the settings in the Standby Server;

# select database_role from v$database;

PHYSICAL STANDBY

# select protection_mode from v$database;

MAXIMUM PERFORMANCE

# select db_unique_name from v$dataguard_config

PRD

# standby_file_management = AUTO

# select * from v$dataguard_status;

Services Informational 0 1 0 NO

08-JUN-13

ARC0: Archival started

Log Transport Services Informational 0 2 0 NO

08-JUN-13

ARC1: Archival started

08-JUN-13

ARC0: Becoming the 'no FAL' ARCH

Log Transport Services Informational 0 4 0 NO

08-JUN-13

...........

...........

...........

...........

...........

FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL

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

TIMESTAMP

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

MESSAGE

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

Log Apply Services Informational 0 38 0 NO

10-JUN-13

Managed Standby Recovery not using Real Time Apply

Log Apply Services Informational 0 39 0 NO

10-JUN-13

FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL

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

TIMESTAMP

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

MESSAGE

--------------------------------------------------------------------------------Managed Standby Recovery not using Real Time Apply

Log Apply Services Informational 0 40 0 NO

10-JUN-13

Managed Standby Recovery not using Real Time Apply

I have attached result of dataguard_status.

regards,

zerandib