Shutdown has four parameters: Normal, transactional, immediate, and abort. If no parameter is specified by default, the value is normal.
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.
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.
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 are not finished are automatically rolled back. No instance recovery is required at startup.
Shutdown ABORT: does not allow new connections, does not wait for the session to end, does not wait for the transaction to end, does not do the checkpoint and does not close the data file. The instance is automatically restored at startup.
In addition, data files are written to the normal, transactional, immediate, and DB buffer cache contents. uncommitted transactions are rolled back and all resources are released, the database is "clean.
For abort, the content of the DB buffer cache is not written into the data file, and transactions that are not committed are not rolled back. The database is not dismount or closed, and the data files are not closed. When the database starts, you need to restore data through the redo log, roll back the transaction through the rollback segment, and release the resource.
startup [force] [restrict] [pfile = filename] [open [recover] [database] | Mount | nomount]
startup open: the default startup parameter is open. Open the database and allow access to the database. All files described in the control file of the current instance have been opened.
startup mount: mount the database. only DBA is allowed to manage the database. Only the control file of the current instance is opened and the data file is not opened.
startup nomount: only the initialization file is allocated to the SGA zone, and the background process of the database is started. The control file and data file are not opened. You cannot access any database.
startup pfile = filename: Start the database with filename as the initialization file, instead of using the default initialization file.
startup force: Stop the running of the current database and restart the database normally.
startup restrict: only users with restricted session permission can access the database.
startup RECOVER: starts the database and starts media recovery.