|Oracle9i Recovery Manager Reference
Release 2 (9.2)
Part Number A96565-01
RMAN Commands , 52 of 59
Text description of the illustration shutdown.gif
To shut down the target database without exiting RMAN. This command is equivalent to using the SQL*Plus
Restrictions and Usage Notes
- Execute this command at the RMAN prompt or within the braces of a
- You cannot use the RMAN
SHUTDOWN command to shut down the recovery catalog database. To shut down this database, start a SQL*Plus session and issue a
IMMEDIATE options all perform a clean close of the database. The
ABORT option does not cleanly close the database; Oracle will perform instance recovery at startup.
- If the database operates in
NOARCHIVELOG mode, then you must shut down the database cleanly and then issue a
MOUNT before a making a backup.
Keywords and Parameters
| Syntax Element
Shuts down the database with normal priority (default option), which means:
- No new connections are allowed after the statement is issued.
- Before the database shuts down, Oracle waits for currently connected users to disconnect
- The next startup of the database will not require instance recovery.
Shuts down the target instance, with the following consequences:
- All current client SQL statements are immediately terminated.
- Uncommitted transactions are not rolled back until next startup.
- Oracle disconnects all connected users.
- Oracle will perform crash recovery on the database at next startup.
Shuts down the target database immediately, with the following consequences:
- Current client SQL statements being processed by Oracle are allowed to complete.
- Uncommitted transactions are rolled back.
- All connected users are disconnected.
Shuts down the target database while minimizing interruption to clients, with the following consequences:
- Clients currently conducting transactions are allowed to complete, that is, either commit or terminate before shutdown.
- No client can start a new transaction on this instance; any client attempting to start a new transaction is disconnected.
- After all transactions have either committed or terminated, any client still connected is disconnected.
Shutting Down a Database by Using the Immediate Option: Example
This example waits for current SQL transactions to be processed before shutting down, then mounts the database:
Shutting Down a Database in NOARCHIVELOG Mode: Example
This example backs up a database running in
STARTUP FORCE DBA;
# executing the preceding commands ensures that database is in proper state
# for NOARCHIVELOG backups
BACKUP COPIES 2 DATABASE;
ALTER DATABASE OPEN;