Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gyan Bahadur.

Asked: August 06, 2018 - 4:03 pm UTC

Last updated: August 20, 2018 - 7:31 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

I have setup DR with maximum performance mode, at any time of instance, how to find the duration of time of data difference between DC and DR.

and Connor said...

There is a couple of commonly used options

1) stats

select * from v$dataguard_stats

which will show you various metrics about the instances, one of them being the apply lag

2) scn comparisons

On each database run:

select current_scn from v$database;

and then run:

select scn_to_timestamp(...) from dual;

for the SCN's returned.




Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, August 22, 2018 - 1:25 pm UTC

nice :)
SQL> select scn_to_timestamp(scn) from(
select to_char(CURRENT_SCN) scn from v$database); 2

22-AUG-18 03.19.39.000000000 PM

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database