0

Scenario:
Let us consider the following:
Oracle 3 node RAC.
RMAN Managed Recovery and Dataguard are configured between production and standby DBs.
The SCNs of 3 nodes are S1, S2, S3 at some point of time respectively.
Smax=max(S1,S2,S3)

Update1(with reference to Balazs Papp Advice):
log_1_x.arc, log_2_y.arc, log_3_z.arc where log file sequence number x<y<z and they contain the sequence number Smax

Please advise on bringing down Orace 11g Standby database MRP as soon as applying the given archive log file with name, log_3_z.arc!

Improve this question
6
  • why do you want to do this? You already got an answer, but it seems that it does not satisfy you. So please describe what is the reason for this question.
    – miracle173
    Apr 10, 2018 at 8:35
  • MRP is brought down for some time to take its backup at that state and then it will be restarted to apply further logs!
    – AVA
    Apr 11, 2018 at 8:36
  • and why do you stop the the MRP during the backup and do not make an online backup?
    – miracle173
    Apr 11, 2018 at 14:19
  • Why do you want stop the MRP to perform a backup? As long as you keep all your archivelog backups, you can perform a point-in-time restore to any scn.
    – vegatripy
    Apr 11, 2018 at 14:45
  • If you actually want to stop managed recovery before a given SCN is applied then Balasz did already post how to do this.
    – miracle173
    Apr 11, 2018 at 15:29

1 Answer 1

Reset to default
1

archive_xyz.log contains the sequence number Smax

This is where you are wrong. You have 3 instances, you have 3 redo threads, so you have 3 archivelogs containing the change at Smax.

Because of this, you need to recover the database until SCN/change, not "archive_xyz.log".

enter image description here

alter database recover managed standby database until change Smax;

Note that, this does not apply the change at Smax.

managed_standby_recovery::=

UNTIL CHANGE Clause

Use this clause to instruct Redo Apply to recover redo data up to, but not including, the specified system change number.

Improve this answer
2
  • Thanks for correcting me! Please may I request your guidance in bringing down MRP only (not recovering) for some time for backup and then it will be restarted!
    – AVA
    Apr 10, 2018 at 3:30
  • > "for some time for backup" What do you want to do? This seems nonsense
    – vegatripy
    Apr 11, 2018 at 12:09

Your Answer

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

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