Oracle Database startup Methods

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

2. startup mount dbname
Install and start. In this mode, you can execute: Database Log archiving, database recovery, and renaming some database files.
For example, system tablespace or log files.
Execute "nomount" and open the control file.

3. startup open dbname
Run "nomount" first, then "mount", and then open all database files including the Redo log file,
In this way, you can access data in the database.

4. startup, which is equal to the following three commands
Startup nomount
Alter database mount
Alter database open

5. startup restrict
Constraint-based startup
This method can start the database, but only allow access by users with certain privileges
When a non-authorized user accesses the service, the following prompt is displayed:
ERROR:
ORA-01035: ORACLE only allows users with restricted session Permissions

6. startup force
Force start Mode
When the database cannot be closed, you can use startup force to close the database.
Shut down the database first, and then execute the normal database startup command

7. startup pfile = parameter file name
Startup method with initialization parameter file
Read the parameter file first, and then start the database according to the settings in the parameter file.
Example: startup pfile = E: \ Oracle \ admin \ oradb \ pfile \ init. ora

8. startup EXCLUSIVE