This discussion is archived
3 Replies Latest reply: Jan 21, 2013 6:29 AM by $phinx19 RSS

Ways of applying archives to DR

$phinx19 Newbie
Currently Being Moderated
Hi All,

I was asked the following question in an Interview.
You have a DR that is out of sync with the production database let's say for 2 days then which is the best possible approach to bring the DR in sync with the production database ASAP
Consider: DB:11g and OS: linux

I gave an usual answer saying that just transfer the archives and fire
recover database using backup controlfile until cancel;
I think there is another way to make it ASAP and that is using RMAN.

  • 1. Re: Ways of applying archives to DR
    karan Pro
    Currently Being Moderated
    that is Roll Forward Physical Standby Database using RMAN incremental backup see

  • 2. Re: Ways of applying archives to DR
    vlethakula Expert
    Currently Being Moderated
    Rollforward physical standby database using rman incremental backups

  • 3. Re: Ways of applying archives to DR
    moreajays Pro
    Currently Being Moderated

    Possible answers ..

    + Above Incremental Roll Forward

    1. Re-create standby database using rman duplicate target database


    2. Restore archives from Backup/Tape & transfer to stby & register logfiles

    3. Transfer archives to standby archive location & fire alter database register logfile '<arch_file>';

    4. Transfer archives to standby & catalog location using RMAN>catalaog start with '<arch_location>';

    5. And sql 'alter database recover managed standby database disconnect from session' in mount mode you know

    Ajay More


  • Correct Answers - 10 points
  • Helpful Answers - 5 points