3 Replies Latest reply: Jan 21, 2013 8:42 AM by moreajays RSS

    Ways of applying archives to DR

    $phinx19
      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
          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
            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
              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