Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
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
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

DROP DATABASE

Syntax

dropDatabase::=

Text description of dropDatabase.gif follows


Text description of dropDatabase



Purpose

Deletes the target database and, if RMAN is connected to a recovery catalog, unregisters it. RMAN removes all datafiles, online logs, and control files belonging to the target database.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description

INCLUDING BACKUPS

Deletes backup sets, proxy copies, image copies, and archived logs associated with the target database from all configured device types.

Note: If you have been using a recovery catalog but run RMAN in NOCATALOG mode when you drop the database, then RMAN will not delete any backups which are known to the recovery catalog but no longer exist in the target database control file.

NOPROMPT

Specifies that you do not want RMAN to prompt you for confirmation before deleting the database. By default, RMAN prompts for confirmation.

Example

Deleting a Database: Example

In this example, you maintain a test database called test1 that is registered in the recovery catalog. You connect to test1 and delete the database files as well as all backups, copies, and archived logs associated with the database:

% rman TARGET SYS/oracle@test1 CATALOG test1/test1@catdb
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;