Take the 2-minute tour ×
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.

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 stackoverflow.com Feb 22 at 13:41

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

    
Have you read dba-oracle.com/concepts/starting_database.htm already? –  Agilox Feb 22 at 10:51
    
yes i read it before. but whats relation with data guard environment? –  DevYudh Feb 22 at 10:57

1 Answer 1

From the documentation:

startup_clauses

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.

MOUNT STANDBY DATABASE

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 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 at 18:29

Your Answer

 
discard

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.