Forum Stats

  • 3,783,301 Users
  • 2,254,754 Discussions
  • 7,880,358 Comments

Discussions

which db should be stop first

User_DLBYE
User_DLBYE Member Posts: 411 Blue Ribbon
edited Mar 30, 2014 10:47PM in General Database Discussions

dear all,

          i have two question?

1)do i need to stop the dataguard while bouncing the application services.

2)while shutting the databases ,which database should be shutdown first main database or dataguard database?

your help appreciated,thanks in advance.


thanks & regards.

Tagged:
User_DLBYE

Answers

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond

    1) no

    2) main

    How do I ask a question on the forums?

    https://forums.oracle.com/message/9362002#9362002

    User_DLBYE
  • 2)while shutting the databases ,which database should be shutdown first main database or dataguard database?

    Post what YOU think the answer is.

    Often all you need is logic and/or common sense to answer some questions.

    1. one purpose of dataguard is to duplicate what happens on 'main'

    2. if you shutdown dataguard first what prevents new activity from happening on main?

    3. if new activity happens on main while dataguard is shutdown will that 'new activity' be replicated to dataguard?

    What conclusion can you draw from your answer to the above questions?

    User_DLBYE
  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,759 Blue Diamond

    No, you do not "need" to shutdown dataguard when stopping / starting / restarting / "bouncing" application servers.   The Oracle databases and dataguard are independent of the application servers.

    If you need to shutdown a database instance for maintenance

    a. The standby can keep running when the primary is down

    b.  If the standby is shutdown with the primary still up, it doesn't receive updates from the primary

    If you need to shutdown all (both) database instances, logically it makes sense to shutdown the primary first and then the standby.

    Hemant K Chitale

    User_DLBYE
This discussion has been closed.