9 Replies Latest reply: Apr 24, 2013 1:29 AM by Artem S. Tsygankov RSS

    How to Reboot Primary Server with Standby correctly

    Artem S. Tsygankov
      Hello!
      I have Primary, two Physical Standby and one Logical Standby Servers with next configuration:

      $ uname -a
      Linux host 2.6.39-200.32.1.el6uek.x86_64 #1 SMP Wed Sep 26 23:11:38 PDT 2012 x86_64 x86_64 x86_64 GNU/Linux

      $ cat /etc/issue
      Oracle Linux Server release 6.3

      SQL> select * from v$version;
      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      PL/SQL Release 11.2.0.3.0 - Production
      CORE 11.2.0.3.0 Production
      TNS for Linux: Version 11.2.0.3.0 - Production
      NLSRTL Version 11.2.0.3.0 - Production

      DGMGRL> show configuration verbose;
      Configuration - work_DataGuardConfig
      Protection Mode: MaxAvailability
      Databases:
      primary - Primary database
      physical1 - Physical standby database
      physical2 - Physical standby database
      Properties:
      FastStartFailoverThreshold = '30'
      OperationTimeout = '30'
      FastStartFailoverLagLimit = '30'
      CommunicationTimeout = '180'
      FastStartFailoverAutoReinstate = 'TRUE'
      FastStartFailoverPmyShutdown = 'TRUE'
      BystandersFollowRoleChange = 'ALL'
      Fast-Start Failover: DISABLED
      Configuration Status:
      SUCCESS

      I need to reboot my Primary DB Server.
      How I must reboot my Primary Server correctly?
      Do I need to shutdown my Physical and Logical Standby Servers till Primary Server be not available?
      Do I need to do some things with Data Guard?
      Please, I would want mini-instruction how I must do this correctly.
      Thanks a Lot!
        • 1. Re: How to Reboot Primary Server with Standby correctly
          Fran
          to shutdown:
          1.shutdown on node
          2.shutdown ASM on node
          3.srvctl stop nodeapps -n <node>

          reboot

          to startup:
          1.srvctl start nodeapps -n <node>
          2.start ASM
          3.start instance
          • 2. Re: How to Reboot Primary Server with Standby correctly
            Artem S. Tsygankov
            Thanks,
            but it isn't a cluster. It's just an instance DB with ASM, yes, and with 3 standby servers - 2 physical and 1 logical.
            • 3. Re: How to Reboot Primary Server with Standby correctly
              JohnWatson
              First, disable the Data Guard Broker fast_start failover (if you have it enabled).
              Second, shutdown the primary database.
              Third, reboot the primary database server.

              That's all. The standbys will wait for the primary to come up again, no problem.

              Edited by: JohnWatson on Apr 18, 2013 12:57 PM
              I see that you do not have fast_start failover enabled, so no problem there.
              • 4. Re: How to Reboot Primary Server with Standby correctly
                Mahir M. Quluzade
                I need to reboot my Primary DB Server.
                How I must reboot my Primary Server correctly?
                Do I need to shutdown my Physical and Logical Standby Servers till Primary Server be not available?
                Do I need to do some things with Data Guard?
                Please, I would want mini-instruction how I must do this correctly.
                Thanks a Lot!
                Hi,

                You can do following steps on primary.
                DGMGRL> show configuration verbose;
                Configuration - work_DataGuardConfig
                Protection Mode: MaxAvailability
                Databases:
                primary - Primary database
                physical1 - Physical standby database
                physical2 - Physical standby database
                Properties:
                FastStartFailoverThreshold = '30'
                OperationTimeout = '30'
                FastStartFailoverLagLimit = '30'
                CommunicationTimeout = '180'
                FastStartFailoverAutoReinstate = 'TRUE'
                FastStartFailoverPmyShutdown = 'TRUE'
                BystandersFollowRoleChange = 'ALL'
                Fast-Start Failover: DISABLED
                Configuration Status:
                SUCCESS
                DGMGRL> edit database physical1 set state = 'APPLY-OFF'; DGMGRL> edit database physical2 set state = 'APPLY-OFF'; DGMGRL> shutdown immediate; DGMGRL> statup; DGMGRL> edit database physical1 set state = 'APPLY-ON'; DGMGRL> edit database physical2 set state = 'APPLY-ON'; Regards Mahir M. Quluzade http://www.mahir-quluzade.com                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                • 5. Re: How to Reboot Primary Server with Standby correctly
                  Artem S. Tsygankov
                  Dear colleagues,
                  thanks a lot for your answers. It helped me in the previous weekends!
                  And I have an other question about a Primary and Standby databases and Data Guard:
                  How to properly setup UTL_MAIL package in my configuration (Primary and Standby Servers), e.g.:
                  1. If I execute @$ORACLE_HOME/rdbms/admin/utlmail.sql on Primary, it will replicate to Standby?
                  2. If I execute alter system set smtp_out_server='smtp.server.local' scope=both, it will replicate to Standby?

                  Edited by: user12024575 on 23.04.2013 6:25
                  • 7. Re: How to Reboot Primary Server with Standby correctly
                    Artem S. Tsygankov
                    Please help me, it's very urgently.
                    Or may be I must create a new topic?
                    • 8. Re: How to Reboot Primary Server with Standby correctly
                      Mahir M. Quluzade
                      Hi,

                      Create new thread!


                      Mahir