![]() ![]() The database will be in an inconsistent state. The SHUTDOWN ABORT has a similar effect as you unplug the power of the server. The SHUTDOWN ABORT is not recommended and only used on some occasions. This option is useful in some cases e.g., a scheduled outage maintenance. ![]() The optional LOCAL mode waits for only local transactions to complete, not all the transactions. The SHUTDOWN TRANSACTIONAL does not require any instance recovery procedure on the next database startup. ![]() When completing all transactions, the database instance disconnects all the currently connected users from the database and shuts down. The database instance also does not accept any new transaction after a SHUTDOWN TRANSACTIONAL. This saves the work for all users without requesting them to log off. The SHUTDOWN TRANSACTIONAL waits for all uncommitted transactions to complete before shutting down the database instance. The SHUTDOWN or SHUTDOWN NORMAL is not really practical because you practically cannot wait for all users to come back to their desks and disconnect from the database. Therefore SHUTDOWN and SHUTDOWN NORMAL commands have the same effect. The NORMAL is the default option if you don’t explicitly specify any option. The SHUTDOWN NORMAL does not require an instance recovery on the next database startup. The database instance will not accept any further database connection. The SHUTDOWN NORMAL option waits for the current users to disconnect from the database before shutting down the database. Let’s examine each option of the SHUTDOWN command. To shut down a currently running Oracle Database instance, you use the SHUTDOWN command as follows: SHUTDOWN ]Ĭode language: SQL (Structured Query Language) ( sql ) Use the SHUTDOWN IMMEDIATE command to shut down the Oracle Database gracefully: SHUTDOWN IMMEDIATEĬode language: SQL (Structured Query Language) ( sql ) Introduction to the Oracle SHUTDOWN statement Summary: in this tutorial, you will learn how to use the Oracle SHUTDOWN statement to shut down the Oracle Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |