Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a question here about Oracle data guard.

After performing a switchover, we shutdown the new standby database and startup it. At this stage, sometimes I find DBA performance in 2 different steps:

  1. startup mount;
  2. startup nomount; then alter database mount standby database;

What's the difference between above commands? Could somebody tell me?

Thanks for helping me and forgive me about my English writing.

share|improve this question

migrated from Feb 22 '14 at 13:41

This question came from our site for professional and enthusiast programmers.

Have you read already? – Agilox Feb 22 '14 at 10:51
yes i read it before. but whats relation with data guard environment? – DevYudh Feb 22 '14 at 10:57

From the documentation:


The startup_clauses let you mount and open the database so that it is accessible to users.

MOUNT Clause

Use the MOUNT clause to mount the database. Do not use this clause when the database is already mounted.


You can specify MOUNT STANDBY DATABASE to mount a physical standby database. The keywords STANDBY DATABASE are optional, because Oracle Database determines automatically whether the database to be mounted is a primary or standby database. As soon as this statement executes, the standby instance can receive redo data from the primary instance.

startup mount is the same as startup nomount; alter database mount.

So there is no practical difference between the two approaches you showed, if the commands are run consecutively (i.e. you are not doing anything else while it is started but not mounted). However, including STANDBY DATABASE in the command clearly shows intent, so I think it's generally better to include it, particularly if you're scripting this as part of a switchover process.

share|improve this answer
are you sure there is no practical difference between these two? – DevYudh Feb 24 '14 at 1:31
@DevYudh - pretty sure; it goes through these stages on a normal startup. Is there a reason you think there is a difference? – Alex Poole Feb 28 '14 at 18:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.