Ask the Expert

What is the difference between an instance and mounting in Oracle?

What is the difference between an instance and mounting?

    Requires Free Membership to View

Let's go through this step by step to understand how these terms are related.

In Oracle, a database is a collection of datafiles, online redo logs, and control files. A database persists across shutdowns. When you terminate Oracle, the data persists in the database, in the files on the server.

Before you can access the database's contents, you must start Oracle. The Oracle instance is the collection of memory and processes running which give you access to the database. If the database server abnormally terminates, the instance will die. But the data still survives in the database. After the server is up and running again, one needs to start the instance before they can access the data.

When you start an instance, there are three stages the instance goes through:

1. NOMOUNT – In this mode, only the parameter file is accessed. Typically, this mode is only used to modify the parameter file's contents or to create the database.

2. MOUNT – In mount mode, the control files are accessed for the first time. Certain maintenance operations require the database to be in MOUNT mode. Mount mode is when the instance acquires memory and spawns the various background processes required for the Oracle instance.

3. OPEN – This mode is the first mode to touch the datafiles and online redo logs. Once Oracle has contacted these files, Oracle lets users connect to the instance so as to interact with the data.

When you issue a normal STARTUP command, the instance proceeds from NOMOUNT to MOUNT to OPEN. You can STARTUP MOUNT the instance, in which case the instance goes from NOMOUNT to MOUNT mode, but does not get to OPEN mode.

This was first published in May 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: