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.

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!

  • 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 '18 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 '18 at 8:36
  • and why do you stop the the MRP during the backup and do not make an online backup?
    – miracle173
    Apr 11 '18 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 '18 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 '18 at 15:29

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.



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

  • 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 '18 at 3:30
  • > "for some time for backup" What do you want to do? This seems nonsense
    – vegatripy
    Apr 11 '18 at 12:09

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .