VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 13, Using the VxDBA Utility
Prerelease 8 September 2005, 8:55am Using VxDBA to Perform Administrative Operations
339
Shutdown NORMAL. Use this menu option to shut down the Oracle instance in normal
situations. When this operation is selected, no new database connections are allowed. Oracle waits
for all currently connected users to disconnect from the database, and then closes and dismounts the
database before shutting down the instance. The next database startup does not require an instance
recovery.
Shutdown TRANSACTIONAL. Use this menu option to shut down the Oracle instance
immediately upon completion of all transactions in progress. When this operation is selected, no
client can start a new transaction on this instance, and a client is disconnected when the transaction
in progress ends. The next database startup does not require an instance recovery.
Shutdown IMMEDIATE. Use this menu option to shut down the Oracle instance immediately.
Use this operation in situations where the database or some application is running irregularly or a
power shutdown is about to occur. When this operation is selected, all current client SQL
statements are terminated immediately, any uncommitted transactions are rolled back, and all
connected users are disconnected. Oracle closes and dismounts the database before shutting down
the instance. The next database startup does not require an instance recovery.
Shutdown ABORT. Use this menu option to shut down the Oracle instance instantaneously by
aborting the database’s instance. Use this operation with extreme caution and only when normal
shutdown or immediate shutdown does not work, you experience problems when starting the
instance, or you need to shut down the instance instantaneously. When this operation is selected, all
connected users are disconnected, current client SQL statements are terminated immediately,
uncommitted transactions are not rolled back, and the instance is terminated without closing the
files. The next database startup requires instance recovery.
The Shutdown NORMAL operation displays a screen similar to the following:
---------------------------------------------------------
VxDBA: Shutdown (NORMAL) Database Instance - PROD
---------------------------------------------------------
Database pre-shutdown script completed.
Database closed.
Database dismounted.
ORACLE instance PROD successfully shut down.
Database post-shutdown script completed.
Press <Return> to continue...