6 Replies Latest reply: Nov 17, 2013 7:51 PM by User478743-OC RSS

    SAN based restoration or RMAN restoration for Dataguard configuration

    User478743-OC

      Hi ,

      We have oracle 11gr2 on aix OS ,I am planning to configure active dataguard for DB size 250 GB.

       

      FOr DB restoration on standby side  if i go for SAN based OS block level  Relication between primary and standby  how to link DB LUn on standby which are  mounted with diffrent LUN name on standby DB.

       

      OR RMAN restoartion is only method to go  for standby DB restoartion ..

       

      My conncerns is if i go for RMAN than it will take more than 8 hours and it will affect my DB performance ..

       

      Please help me suggest which approch is better ? If it SAN based than how to link LUn to DB file .

      Thanks in Advance.

        • 1. Re: SAN based restoration or RMAN restoration for Dataguard configuration
          TSharma-Oracle

          We use SRDF for our DR solution for some case,but i have not created data guard with SAN copy method But if I think logically it seems doable. You can use "db_file_name_convert" parameter in your parameter file to tell standby database for new datafile locations like you do in normal creation of the standby database.

           

          And, You can take your RMAN database after business hours which will not impact your DB performance. Take the RMAN backup with multiple parallel channels to speed up the backup. It should not take 8 hours if you run it with multiple channels.

          • 2. Re: SAN based restoration or RMAN restoration for Dataguard configuration
            User478743-OC

            Hi TSharma,

             

            For SAN based replication how init parameter get transfer to standby init ...Do u think it will be through SAN replication ?

             

            If it is through SAN based than after replication finish i just need to start DB in standby mode that's it or is there any additional step required ...

             

            OR RMAN is safe and tested solution so i should go for RMAN ?

            • 3. Re: SAN based restoration or RMAN restoration for Dataguard configuration
              TSharma-Oracle

              You can manually copy the init parameter file to the destination. It will be a one time copy. Again I have not played with it but logically it seems doable. Basically you need to all the steps you do for normal standby creation. SAN copy is just a substitution for RMAN to create a copy of your production.

               

              Like I said, You can use RMAN and it is a well known obvious method, If you are concerned about performance like I said, you can take the backup in off business hours OR you can use your daily backup and apply the archives. OR use multiple channels in RMAN which will increase your  backup performance.

              • 4. Re: SAN based restoration or RMAN restoration for Dataguard configuration
                User478743-OC

                Thanks for the reply but one more question please

                 

                Primary DB name: Test1

                Primary DB Unique name :Test1

                Stand BY DB name :Test1

                Stand by DB unique name :Test2

                 

                So my question is in listener.ora on primary entry should be as shown below .

                 

                SID_LIST_LISTENER =
                  (SID_LIST =
                    (SID_DESC =
                        (ORACLE_HOME = /u01/app/oracle/product/OraHome111)
                     (SID_NAME = Test2)
                    )
                   )

                LISTENER =
                  (DESCRIPTION =
                    (ADDRESS = (PROTOCOL = TCP)(HOST = <auxiliary host>)(PORT = 1521))
                  )

                • 5. Re: SAN based restoration or RMAN restoration for Dataguard configuration
                  mseberg

                  Hello;

                   

                  I don't see "global_dbname" in your example.

                   

                   

                   

                  Yours

                   

                   

                  SID_LIST_LISTENER =

                    (SID_LIST =

                    (SID_DESC =

                    (ORACLE_HOME = /u01/app/oracle/product/OraHome111)

                    (SID_NAME = Test2)

                    )

                    )

                   

                  LISTENER =

                    (DESCRIPTION =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = <auxiliary host>)(PORT = 1521))

                    )

                   


                  Mine

                   

                   

                  SID_LIST_LISTENER =

                    (SID_LIST =

                    (SID_DESC =

                    (SID_NAME = PLSExtProc)

                    (ORACLE_HOME = /u01/app/oracle/product/11.2.0.3)

                    (PROGRAM = extproc)

                    )

                    (SID_DESC =

                    (global_dbname = STANDBY_DGMGRL.myhost.com)

                    (ORACLE_HOME = /u01/app/oracle/product/11.2.0.3)

                    (sid_name = STANDBY)

                    )

                  )

                   

                  ADR_BASE_LISTENER = /u01/app/oracle

                   

                  INBOUND_CONNECT_TIMEOUT_LISTENER=120

                   

                   

                   

                   

                  Best Regards

                   

                  mseberg

                  • 6. Re: SAN based restoration or RMAN restoration for Dataguard configuration
                    User478743-OC

                    HI mseberg,

                     

                    But i don't see "global_dbname" in Primary DB  Side also ...

                     

                    Is it mandatory to have golbal DB name on both(Primary,Secondary)  the side ....?

                     

                    Thannks .