1 2 Previous Next 26 Replies Latest reply on Jul 24, 2015 12:47 PM by Beauty_and_dBest

    EBS 11i Dataguard Setup

    Beauty_and_dBest

      Hi ALL,

       

      EBS 11i

      9i

      rhel5

       

      Is there special process for configuring EBS database for dataguard physical standby?

       

      I was able to configure the physical standby for its database, but if you try to switchover from primary to standby, the standby can not do log switch.

       

      Please help...

       

       

      Thanks a lot,

      jc

        • 1. Re: EBS 11i Dataguard Setup
          Bashar.

          Hi,

           

          Have you read this document?

           

          Business Continuity for Oracle E-Business Release 12.1 Using Oracle 11g Release 2 Physical Standby Database (Doc ID 1070033.1)

           

          Regards,

          Bashar

          1 person found this helpful
          • 2. Re: EBS 11i Dataguard Setup
            Pravin Takpire

            there is no special setup for EBS database. Dataguard will work similar fashion for EBS database as for any other normal database.

            For your error on Standby -- please post more details.

            regards

            Pravin

            1 person found this helpful
            • 3. Re: EBS 11i Dataguard Setup
              Beauty_and_dBest

              Hi Bashar,

               

              That note is for 12.1  and 11g? Mine is 11i and 9i. Is it applicable?

               

              Thanks.

              • 4. Re: EBS 11i Dataguard Setup
                Beauty_and_dBest

                Hi Pravin and ALL,

                 

                11i

                9i

                rhel6

                 

                I have configured dataguard physical standby for the database.

                This is the config:

                 

                PRIMARY INIT.ORA

                ===============

                db_name         = DEV

                instance_name   = STBY

                service_names = STBY

                lock_name_space = STBY

                fal_client = STBY

                fal_server = DEV

                LOG_ARCHIVE_DEST_1='LOCATION=/u02/oradev/devdb/9.2.0/dbs/arch'

                log_archive_dest_2 = 'SERVICE=DEV LGWR ASYNC NOAFFIRM'

                LOG_ARCHIVE_DEST_STATE_1=enable

                LOG_ARCHIVE_DEST_STATE_2=enable

                standby_archive_dest = /u02/oradev/devdb/9.2.0/dbs/arch

                LOG_ARCHIVE_TRACE=127

                log_archive_format = %t_%s.dbf

                standby_file_management = auto

                REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE

                REMOTE_ARCHIVE_ENABLE=true

                 

                 

                STANDBY INIT.ORA

                ===============

                db_name       = DEV

                instance_name = DEV

                service_names = DEV

                fal_client    = DEV

                fal_server = STBY

                log_archive_dest_1 = 'LOCATION=/u02/oradev/devdb/9.2.0/dbs/arch'

                log_archive_dest_2 = 'SERVICE=STBY LGWR ASYNC NOAFFIRM'

                LOG_ARCHIVE_DEST_STATE_1=enable

                LOG_ARCHIVE_DEST_STATE_2=enable

                log_archive_format = %t_%s.dbf

                standby_archive_dest = /u02/oradev/devdb/9.2.0/dbs/arch

                remote_login_passwordfile = EXCLUSIVE

                standby_file_management = auto

                REMOTE_ARCHIVE_ENABLE=true



                When I login to primary and issue command > ALTER SYSTEM SWITCH LOGFILE;  it is just waiting forever, and can not switch log file. I do not know what resource is it waiting for, as it does not show any message in the alert.log


                Please help...


                Thanks,

                jc

                • 5. Re: EBS 11i Dataguard Setup
                  richiev

                  Hi,

                   

                  We're on 11.5.10.2 and 11.2.0.4; we've implemented our Standby system using Doc ID 1068913.1

                  Business Continuity for Oracle E-Business Release 11i Using Oracle 11g Physical Standby Database - Single Instance and Oracle RAC (Doc ID 1068913.1)


                  Even though you're on 9i most of the doc will be applicable to you.  We would have followed a similar process to setup a Dataguard Standby DB when we were on 9i.


                  Good Luck!


                  Richie.

                  1 person found this helpful
                  • 6. Re: EBS 11i Dataguard Setup
                    Pravin Takpire

                    Basic disaster recovery scenario remains same whether you are on 9i/11i or R12/12C. Incasse of failure you should be able to start Database and Application on DR site servers.

                    Now question remains

                    1.) What is your plan? Only Database side DR setup and not about application side.

                    If this is the case then Dataguard given its setup for 9i will work.

                    and if You can do basic setup change in application set after changeover (Standby becoming Primary) you can access application

                     

                    regards

                    Pravin

                    1 person found this helpful
                    • 7. Re: EBS 11i Dataguard Setup
                      richiev

                      Hi Jenna,

                       

                      Try killing the ARC processes on primary; they will respawn.

                      The ARC processes only read the tnsnames.ora on instance startup.


                      Regards,

                       

                      Richie.

                      1 person found this helpful
                      • 8. Re: EBS 11i Dataguard Setup
                        Pravin Takpire

                        Set LOG_ARCHIVE_DEST_STATE_2=defer on Stndby Database once you switch over.

                        regards

                        Pravin

                        1 person found this helpful
                        • 9. Re: EBS 11i Dataguard Setup
                          Beauty_and_dBest

                          Hi Pravin,

                           

                          Does "defer" mean it does not apply the archive log changes  to the standby?

                           

                          I tried

                          SQL> alter system switch logfile;

                          (Still hangs)

                           

                          But its was able to create log 65, 66 ( two logs only for my two log groups?)

                          but cat not create 67?

                           

                           

                          Thanks.

                          • 10. Re: EBS 11i Dataguard Setup
                            Krishna-Oracle

                            Yes. Defer will avoid transferring log files to standby.

                            It is purely database related issue.

                            We need to diagnose this issue with trace log.

                            1 person found this helpful
                            • 11. Re: EBS 11i Dataguard Setup
                              Beauty_and_dBest

                              Hi Krishna and ALL,

                               

                              I observed that the redo log are not being recycled or overwritten in a round-robin fashion. If I add a new log group the hanging log switch gets completed.

                              So it seems con not be recycled and offloaded to the archive logs? weird

                               

                              Please help why this behaviour.

                               

                              Thanks.

                              • 12. Re: EBS 11i Dataguard Setup
                                Beauty_and_dBest

                                Hi ALL,

                                 

                                I resolved my issue now. I just being dumb of me

                                 

                                In the init.ora  I see that it has # comment.


                                #log_archive_start = true


                                Since this is the standby db before, it did not matter if its commented out.

                                But when I switchover to it, now the issue arise which it can not auto archive the online redo, hence ALTER SYSTEM SWITCH LOGFILE is waiting forever


                                Thanks ALL.

                                1 person found this helpful
                                • 13. Re: EBS 11i Dataguard Setup
                                  Beauty_and_dBest

                                  Hi Pravin,

                                   

                                  ****1.) What is your plan? Only Database side DR setup and not about application side.

                                           If this is the case then Dataguard given its setup for 9i will work.

                                           and if You can do basic setup change in application set after changeover (Standby becoming Primary) you can access application


                                  I plan only the Database side DR.

                                  How do I point my Apps to the standby-now-primary STBY database? Do I need to apply post-cloning?


                                  Thanks

                                  • 14. Re: EBS 11i Dataguard Setup
                                    Bashar.

                                    Hi,

                                     

                                    After your standby database becomes a primary one, you just need to run adcfgclone.pl on the apps tier and provide the database connection information.

                                     

                                    Regards,

                                    Bashar

                                    1 person found this helpful
                                    1 2 Previous Next