First page Back Continue Last page Graphics
RMAN DROP DATABASE
New command removes
- Controlfiles
- Datafiles
- Logfiles
- Spfile
Optionally drops
- Archivelogs
- Backup pieces
- Image copies
Unregisters database
Database in mount exclusive mode
Notes:
Oracle 10g introduces a DROP DATABASE command. It is offered as both a SQL statement and an RMAN command. The RMAN command offers more functionality than does the SQL statement. For example, the RMAN command offers the ability to optionally drop the archivelogs and backup pieces as shown in this example:
RMAN> DROP DATABASE INCLUDING BACKUPS;
Dropping the database drops the controlfiles, datafiles, logfiles and, if used, the SPFILE. If the database is connected to an RMAN catalog when the database is dropped, RMAN also unregisters the database from the catalog.
The database must not be open; it must be mounted in exclusive mode.
References:
Metalink Note:251412.1
Oracle Database Recovery Manager Reference 10g Release 2 (10.2)