Oracle Startup Shutdown Command

Shut down:
1. Shutdown normal
Do not allow new connections, wait for the session to end, wait for the transaction to end, make a checkpoint, and close the data file. No instance recovery is required at startup.

2, Shutdown transactional
Do not allow new connections, do not wait for the session to end, wait for the transaction to end, make a checkpoint, and close the data file. No instance recovery is required at startup.

3, Shutdown immediate
Do not allow new connections, do not wait for the session to end, do not wait for the transaction to end, make a checkpoint, and close the data file. Transactions that do not end are automatically rollback. No instance recovery is required at startup.

4, Shutdown abort
Do not allow new connections, do not wait for the session to end, do not wait for the transaction to end, do not checkpoint, and do not close the data file. Automatic instance recovery on startup. Shutdown abort closes immediately. But the next time it starts, it's probably going to be a problem. Use with caution.

Start:
1, Startup Nomount
Non-installation boot, this way startup executable: Rebuild the control file, rebuild the database, read the Init.ora file, start the instance, that is, start the SGA and background process, this boot only need Init.ora files.

2. Startup Mount (dbname)
Installation starts, this way starts under executable: Database log archive, database media recovery, bring data files online or offline, relocate data files, redo log files.
Execute "Nomount", and then open the control file to confirm the location of the data file and the online log file, but the data and log files are not checked for verification at this time.

3. Startup open (dbname)
You can access the data in the database by executing "nomount", then executing "mount", and then opening all the database files, including the redo log file.

4, startup equals the following three commands
Startup Nomount
ALTER DATABASE Mount
ALTER DATABASE Open

5, startup restrict
Constrained mode to start the database, but only a privileged user is allowed to access it, and the following prompt appears when a non-privileged user accesses it:
Error:ora-01035:oracle only allow users with RESTRICTED SESSION permissions to use

6. Startup force
Force start mode, when the database cannot be closed, you can use startup force to complete the database shutdown, first shut down the database, and then execute the normal start database command

7. Startup pfile= parameter file name
Start with the initialization parameter file, read the parameter file, and start the database according to the settings in the parameter file
Example: Startup Pfile=e:\oracle\admin\oradb\pfile\init.ora

8, startup EXCLUSIVE
Exclusive and shared boot

Oracle Startup Shutdown Command