4 Replies Latest reply: Apr 1, 2013 7:29 PM by Justin_Mungal RSS

    Identify failover server

    989272
      Hi All

      I`m installing Oracle 11.2.0.3 software with partitioning enabled on few servers, some of these servers switches to another server when fail-over happens.

      I would like to identify the fail-over server and install new software with partitioning enabled on the fail-over server too.

      How do we do that? I mean how to identify fail-over server details?
        • 1. Re: Identify failover server
          EdStevens
          986269 wrote:
          Hi All

          I`m installing Oracle 11.2.0.3 software with partitioning enabled on few servers, some of these servers switches to another server when fail-over happens.

          I would like to identify the fail-over server and install new software with partitioning enabled on the fail-over server too.

          How do we do that? I mean how to identify fail-over server details?
          What is handling the failover? Oracle Data Guard? Some sort of clustering mechanism? At the OS level?
          • 2. Re: Identify failover server
            989272
            We have Veritas Cluster Manager in our environment.

            Few of the databases were enabled with data-guard.

            I would like to identify the switch-on servers, I`m having trouble to identify it, as I`m new to Oracle.
            • 3. Re: Identify failover server
              975957
              Not sure if this is UNIX or Windows.

              For UNIX, the main file that contains all the Veritas Cluster Server (VCS) configuration is : /etc/VRTSvcs/conf/config/main.cf

              Now, VCS has the concept of Service Groups (that is a couple of things that belong together, that can fail-over together).

              A typical Service Group for Oracle would contain, Disks (or diskgroups) that needs to be online before Oracle can come online, and perhaps filesystems that needs to be mounted before Oracle can come online.


              An example of this Service Group in the main.cf file would look like this......
              (see below)


              What is important here .... note the names of all the machines that can run this Service Group (nodev, nodew, nodex, nodey and nodez)

              Also note the order in which they appear (each has a value of "importance" ... so, if all are down, it will try to come online on nodew first (lower order) )

              Lastly, the fail-over policy ... this will tell you (if it is present) where stuff will fail-over to if it fails on the node that it is online.




              group GROUP_avonprod (
                   SystemList = { nodev = 0, nodew = 1, nodex = 2,       nodey = 3,  nodez = 4 }
                   AutoStartList = { nodev, nodew, nodex, nodey, nodez }
                   FailOverPolicy = RoundRobin
                   )

                   DiskGroup DG_avonprod (
                        DiskGroup = oraavonprod
                        )

                   Volume VOL_oraavonprod01 (
                        Volume = oraavonprod01
                        DiskGroup = oraavonprod
                        )

                   Mount MOUNT_oraavonprod01 (
                        MountOpt = rw
                        FsckOpt = "-y"
                        BlockDevice = "/dev/vx/dsk/oraavonprod/oraavonprod01"
                        MountPoint = "/oraavonprod01"
                        FSType = vxfs
                        )

                   Netlsnr LISTENER_avonprod (
                        TnsAdmin = "/oraavonprod01/app/oracle/product/10.2.0/network/admin"
                        Owner = oracle
                        EnvFile = "/e2open/home/oracle/.orafunc_AVONPROD"
                        Home = "/oraavonprod01/app/oracle/product/10.2.0"
                        Listener = listener_avonprod
                        )

                   Oracle ORA_avonprod (
                        Pfile = "/oraavonprod01/app/oracle/admin/avonprod/pfile/initavonprod.ora"
                        Owner = oracle
                        Home = "/oraavonprod01/app/oracle/product/10.2.0"
                        Sid = avonprod
                        )



                   LISTENER_avonprod requires ORA_avonprod
                   MOUNT_oraavonprod01 requires VOL_oraavonprod01
                   MOUNT_oraavonprod02 requires VOL_oraavonprod02
                   MOUNT_oraavonprod03 requires VOL_oraavonprod03
                   ORA_avonprod requires MOUNT_oraavonprod01
                   VOL_oraavonprod01 requires DG_avonprod


                   // resource dependency tree
                   //





              ------

              To see where the groups are online, you can either use the GUI (a lot of people do use that), or on any of the machines that forms part of the cluster, run #/opt/VRTS/bin/hastatus -sum




              Hope that helps
              • 4. Re: Identify failover server
                Justin_Mungal
                You can check the Data Guard role from v$database.
                SQL> select database_role from v$database;
                
                DATABASE_ROLE
                ----------------
                PRIMARY
                Make your life easier: read the Data Guard Concepts and Administration manual.