2 Replies Latest reply: Nov 19, 2013 11:16 PM by Mahir M. Quluzade RSS

    Online Redo logs instead of Standby Redo logs

    Tom

      RDBMS Version: 11.2.0.3/Platform : RHEL 6.3

       

      To migrate a 3TB Database to a new DB server , we are going to use RMAN DUPLICATE.

       

       

      Step1. Take full backup of DB + Standby Control file at primary site and transfer the Bkp files to Standby site

       

      Step2. At standy site, we will run the RMAN duplicate target database for standby

       

       

       

      After the above step, we don't want to create the standby redo logs because the newly restored DB in standby server is going to be the new Prod DB which application will be pointing to.

       

      So, Can I skip the Standby Redo log creation part and create Online redo logs instead  ?

       

      As mentioned earlier, Our objective is not to create a proper Dataguard Standby DB setup. We just want to clone our DB to another server using RMAN Duplicate.

        • 1. Re: Online Redo logs instead of Standby Redo logs
          mseberg

          Hello;

           

          Yes you can. But I would create both since your Primary database could switch modes and become a Standby.

           

          You could alway create them later too.

           

          Best Regards

           

          mseberg

          • 2. Re: Online Redo logs instead of Standby Redo logs
            Mahir M. Quluzade

            Tom wrote:

             

            RDBMS Version: 11.2.0.3/Platform : RHEL 6.3

             

            To migrate a 3TB Database to a new DB server , we are going to use RMAN DUPLICATE.

             

             

            Step1. Take full backup of DB + Standby Control file at primary site and transfer the Bkp files to Standby site

             

            Step2. At standy site, we will run the RMAN duplicate target database for standby

             

             

             

            After the above step, we don't want to create the standby redo logs because the newly restored DB in standby server is going to be the new Prod DB which application will be pointing to.

             

            So, Can I skip the Standby Redo log creation part and create Online redo logs instead  ?

             

            As mentioned earlier, Our objective is not to create a proper Dataguard Standby DB setup. We just want to clone our DB to another server using RMAN Duplicate.

            Hi,

             

            Take full backup of DB + Standby Control

            We just want to clone our DB to another server using RMAN Duplicate

             

            If you want only clone database of production, why you  are take Standby controlfile?

            If you don't want create standby  database then, why you using DUPLICATE  command with FOR STANDBY option.

            You can  use DUPLICATE command for clone database, without for standby option.

             

            If you  say no, we want create standby database and we will perform swithover,

            then yes, you can use online redo  logs for max performance mode.

            and you can create standby redo logs on all database, but this redo logs will use by database when database role

            is standby.

             

             

            Regards

            Mahir M. Quluzade