3.16 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 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.
Semantics
Syntax Element | Description |
---|---|
|
Performs an inconsistent shutdown of the target instance, with the following consequences:
|
|
Performs an immediate, consistent shutdown of the target database, with the following consequences:
|
|
Performs a consistent shutdown of the target database with normal priority (default option), which means:
|
|
Performs a consistent shut down of the target database while minimizing interruption to clients, with the following consequences:
|
Examples
Example 3-64 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-65 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;