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 is DG is working fine?

unknown-2698904Jul 2 2014 — edited Jul 20 2014

Hi all,

11g

Aix

We have dataguard configured on our prod primary and physical standby database.

My boss ask me to create a script to email the tech group daily at 8am the status of replication(apply logs).

Since I am using dataguard broker. I will do the script as follows:

===========================

oracle@prodsvr:/home/oracle>dgmgrl

DGMGRL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - 64bit Production

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/Manager

Connected.

DGMGRL> show configuration;

Configuration - DGConfig1

Protection Mode: MaxPerformance

Databases:

PROD - Primary database

PRODDR - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

DGMGRL> exit

=========================

How do I save the above logs and email it? (I know how to email already) I just need the logfile.

Thanks,

This post has been answered by FreddieEssex on Jul 18 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2014

Added on Jul 2 2014

#data-guard, #performance-availability

22 comments

12,009 views