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
RCMRF155

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

RCMRF90359shutdown::=

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

RCMRF90360Example 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;

RCMRF90361Example 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;
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF