Four basic startup methods for Oracle databases

The following articles mainly introduce four common startup methods for Oracle databases, including startup nomount, startup mount dbname, and startup open dbname, the following describes the specific content of the article.

1. startup nomount

Non-installation startup: In this mode, you can execute re-build the control file, re-build the database, start the instance, that is, start the SGA and background processes. To start this kind of startup, you only need the init. ora file.

2. startup mount dbname

Installation and startup: In this mode, you can execute: Database Log archiving, database recovery, and renaming some database files, such as system tablespace or log files. Execute "nomount" and open the control file.

3. startup open dbname

First, execute "nomount", then execute "mount", and then open all database files including Redo log files. In this way, you can access data in the database.

4. startup equals to the following three commands:

Startup nomount

Alter database mount

The related content above alter database open is an introduction to. I hope you will get some benefits.

The above content is an introduction to the four Oracle Database startup methods. I hope you will get something.

Article by: http://database.csdn.net/page/ee788d7a-8fea-4067-a2bf-4a79423ed270