Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

SHUTDOWN

Purpose

Use the SHUTDOWN command to shut down the target database without exiting RMAN. This command is equivalent to the SQL*Plus SHUTDOWN statement.

See Also:

Oracle Database Administrator's Guide for information on how to start up and shut down a database, and SQL*Plus User's Guide and Reference for SHUTDOWN syntax

Usage Notes

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 SHUTDOWN statement.

If the database operates in NOARCHIVELOG mode, then you must shut down the database cleanly and then issue a STARTUP MOUNT before a making a backup.

Syntax

shutdown::=

Description of shutdown.gif follows
Description of the illustration shutdown.gif

Semantics

Syntax Element Description
ABORT Performs an inconsistent shutdown of the target instance, with the following consequences:
  • All current client SQL statements are immediately terminated.

  • Uncommitted transactions are not rolled back until next startup.

  • All connected users are disconnected.

  • Instance recovery is performed on the database at next startup.

IMMEDIATE Performs an immediate, consistent shutdown of the target database, with the following consequences:
  • Current client SQL statements being processed by the database are allowed to complete.

  • Uncommitted transactions are rolled back.

  • All connected users are disconnected.

NORMAL Performs a consistent shutdown of the target database with normal priority (default option), which means:
  • No new connections are allowed after the statement is issued.

  • Before shutting down, the database waits for currently connected users to disconnect

  • The next startup of the database does not require instance recovery.

TRANSACTIONAL Performs a consistent shut down of 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.


Examples

Example 3-48 Shutting Down a Database with the Immediate Option

This example waits for current SQL transactions to be processed before shutting down, then mounts the database:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

Example 3-49 Shutting Down a Database in NOARCHIVELOG Mode

This example backs up a database running in NOARCHIVELOG mode:

STARTUP FORCE DBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
# executing the preceding commands ensures that database is in proper state 
# for NOARCHIVELOG backups
BACKUP DATABASE;
ALTER DATABASE OPEN;