Four Oracle Database startup Methods

I have introduced the Oracle database startup and shutdown, and I will introduce the four Oracle Database startup methods ".

Four Oracle Database startup Methods

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 Redolog files. In this way, you can access data in the database.

4. startup equals to the following three commands:

Startup nomount

Alter database mount

Alter database open

By learning these four startup methods, Oracle Database startup will no longer be difficult, and it will lay a solid foundation for you to better master the Oracle database operation skills in the future.