AVA
AVA

Reputation: 2558

How to get the oracle dataguard log transfer and applying status?

Logs are transferred from primary db instanes to stand-by db and applied continuously.

Please advise how to get the report in the following format in browser at some frequency(say 5sec/10sec) for monitoring purposes at stand-by db(prefer to any built-in function or class in oracle dataguard):

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

log_name instance created_time tx_start tx_end tx_duration tx_success apply_start apply_end apply_duration apply_success

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

...

...

...

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

Upvotes: 0

Views: 480

Answers (2)

DDDBA
DDDBA

Reputation: 11

v$managed_standby is very usefully to check the DG status.

Upvotes: 0

gsalem
gsalem

Reputation: 2028

Have a look at the V$RECOVERY.... views (e.g. look here and the following views). They have lots of info on recovery processes and stats.

Upvotes: 0

Related Questions