1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Auto DB Start on Server restart

Discussion in 'Server Administration and Options' started by prashant, Jan 17, 2011.

  1. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    DB Release : 11.2.0.1
    OS : SunOS 5.10 Generic_141414-02 sun4u sparc SUNW,Ultra-80
    Technologies : Oracle Dataguard, physical Standby, Dataguard broker with Fast Start Failover

    Hi All,

    I need to implement Auto DB start on server restart for the following scenario:-

    Case:
    Shutdown Server 1 (Primary) and verify that Server 2 take the control(standby to primary with Fast Start failover). Then startup Server 1

    Requirement:
    Server 1 when started should automatically bring up Database in standby server.

    Like above there could be many other cases like both servers coming down together, both servers coming down with some time gap(first stdby then primary or vice versa) etc. The requirement in each case would be that our server when started should bring up database in appropriate mode.

    Can anyone assist me with the same.

    Thanks in advance.

    -Prashant
     
  2. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Hi,

    Can anyone assist on this please?

    The requirement went on hold initally, and it is now required to be implemented.

    Thanks in advance.

    Best Regards,
    Prashant
     
  3. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Hi Folks,

    I was reading about Oracle Restart which is a part of Oracle 11gR2 grid infrastructure. This certainly makes things easier in my case, but the only problem would be the cost & complexity involved here. I need to deploy Oracle Dataguard within Oracle Grid infrastructure installation.

    I am looking out for other alternatives. I would be thankful if someone can guide me on this.

    Thank you.

    Best Regards,
    Prashant