Oracle Automatic Startup method

Oracle Common Startup methods:

1, Startup Nomount

Non-installation startup, this way to launch executable: Rebuild control files, rebuild the database read Init.ora file, start instance, that is, start the SGA and background process, this startup requires only Init.ora files.

2, startup Mount DBName

Install startup, this way to start under executable:

Database log archiving,

Database Media Recovery,

Bring the data file online or offline,

Reposition the data file and redo the log file.

Perform "Nomount" and then open the control file to confirm the location of the data file and the online log file, but do not check the data files and log files at this time.

3, Startup Open dbname

You can access the data in the database by executing "nomount" and then performing mount, and then opening all the database files, including the Redolog file, in this way.

4, startup, equal to the following three orders

startup nomount
alter database mount
alter database open

5, startup restrict

Constraint start

This way the database can be started, but only if a privileged user is allowed access to unprivileged users, the following prompts appear:

ERROR:

Ora-01035:oracle only allow users with restricted session permissions to use

6, Startup force

Forced start mode

When you cannot close the database, you can use startup force to complete the shutdown of the database

Close the database before performing the normal start database command

7, startup pfile= parameter filename

Startup method with initialization parameter file

Read the parameter file first, then start the database by setting in the parameter file

Example: Startup Pfile=e:\oracle\admin\oradb\pfile\init.ora

8, startup EXCLUSIVE