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.


Regards,
Sphinx
  • 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 http://docs.oracle.com/cd/B28359_01/server.111/b28294/rman.htm#CIHIAADC

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

    check

    http://shivanandarao.wordpress.com/2012/03/26/roll-forward-physical-standby-database-using-rman-incremental-backup/
  • 3. Re: Ways of applying archives to DR
    moreajays Pro
    Currently Being Moderated
    Hi,

    Possible answers ..

    + Above Incremental Roll Forward

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

    Refer:
    http://www.orafaq.com/node/2503

    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 ..as you know


    Thanks,
    Ajay More
    http://www.moreajays.com

Legend

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