Difference between startup mount and startup mount exclusive

October 20, 2009 at 1:52 pm (Oracle) (, )


Fact: startup mount and startup mount exclusive are the same because default for startup mount is exclusive

STARTUP [FORCE][RESTRICT][NOMOUNT][MIGRATE][QUIET]
[PFILE=]
[MOUNT [EXCLUSIVE] x |
OPEN
]

For RAC and non-RAC databases, startup mount and startup mount exclusive have no differences.

startup mount exclusive is meant to shutdown all instances on a RAC and bringing up only one instance.

On a RAC database, when init parameter on all instances for cluster_database is set to TRUE, you will have to set cluster_database to FALSE and then shutdown all the RAC instances and then startup only one instance with startup mount exclusive. Since exclusive is default for startup mount, issuing startup mount is sufficient.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.