Oracle startup and shutdown routines

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.