0

Is the difference between the SCN of primary and secondary a good indicator of RPO?

We are planning for the below logic to get the RPO.

  1. Get the current SCN from secondary.

  2. Get the time stamp of the above SCN(as A).

  3. Get the current SCN from primary.

  4. Get the time stamp of the above SCN(as B).

  5. Calculate the RPO as the difference of B-A.

Is this logic valid?

Improve this question
1
  • Can you provide more information such as Oracle version, protection mode, log shipping method etc?
    – atokpas
    Commented Apr 28, 2017 at 6:42

1 Answer 1

Reset to default
1

If you see the standby summary in DGMGRL then it is quite straightforward to know whether your configuration is satisfying your RPO and RTO(derived from business needs) or not.

DGMGRL> show database orcl_stby;

Database - orcl_stby

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds (computed 0 seconds ago)
  Apply Lag:       0 seconds (computed 0 seconds ago)
  Apply Rate:      916.00 KByte/s
  Real Time Query: ON

The transport lag is measured as the delta from the primary database last update and the standby last received redo. This can effect your RPO. If you have to fail over your primary database at this time, redo data that did not arrive at the standby database server will be lost.

Similarly Apply Lag represent your RTO which indicates how far behind your standby database server is compared to the primary when it comes to applying redo data.

Improve this answer
1
  • 1
    I would argue that RTO and RPO are objectives. Requirements set by business owner. What you would do with above numbers is measuring whether you are meeting these requirements. At least for RPO. RTO is not that simple to calculate. A value in Apply Lag might give you a starting point since you will not failover until all redo is applied. But failover itself consists of more steps needed to restore business operations which will affect your RTO. RTO is measured by doing a DR test.
    – Marko Vodopija
    Commented Apr 28, 2017 at 7:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.