Drop 10g Database using RMAN

SQL> startup mount;

SQL> alter system enable restricted session;

$ rman target sys/dupdb@dupdb catalog rman/rman@catdb

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Apr 22 16:53:41 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DUPDB (DBID=3693079167, not open)

connected to recovery catalog database

RMAN> DROP DATABASE INCLUDING BACKUPS;

database name is "DUPDB" and DBID is 3693079167

Do you really want to drop all backups and the database (enter YES or NO)? yes

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

List of Backup Pieces

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

251149  251145  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_13_1_813321003

251150  251146  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_14_1_813321069

251170  251167  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_15_1_813321073

251244  251240  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_16_1_813421585

251245  251241  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_17_1_813421589

251246  251242  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_18_1_813421655

251264  251261  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DRPROD_19_1_813421660

251490  251486  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DUPDB_1_1_813429205

251491  251487  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DUPDB_2_1_813429213

251492  251488  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DUPDB_3_1_813429215

251493  251489  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DUPDB_4_1_813429281

251514  251512  1   1   AVAILABLE   DISK        /zone/catdb/backup/drprod__DUPDB_5_1_813429285

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_13_1_813321003 recid=13 stamp=813321007

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_14_1_813321069 recid=14 stamp=813321069

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_15_1_813321073 recid=15 stamp=813321074

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_16_1_813421585 recid=16 stamp=813421586

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_17_1_813421589 recid=17 stamp=813421593

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_18_1_813421655 recid=18 stamp=813421655

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DRPROD_19_1_813421660 recid=19 stamp=813421661

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DUPDB_1_1_813429205 recid=1 stamp=813429206

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DUPDB_2_1_813429213 recid=2 stamp=813429214

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DUPDB_3_1_813429215 recid=3 stamp=813429216

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DUPDB_4_1_813429281 recid=4 stamp=813429281

deleted backup piece

backup piece handle=/zone/catdb/backup/drprod__DUPDB_5_1_813429285 recid=5 stamp=813429286

Deleted 12 objects

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

List of Archived Log Copies

Key     Thrd Seq     S Low Time  Name

------- ---- ------- - --------- ----

251481  1    694     A 21-APR-13 /zone/drprod/arch1/drprod_1_694_800019715.arc

251482  1    695     A 21-APR-13 /zone/drprod/arch1/drprod_1_695_800019715.arc

251483  1    696     A 22-APR-13 /zone/drprod/arch1/drprod_1_696_800019715.arc

251484  1    697     A 22-APR-13 /zone/drprod/arch1/drprod_1_697_800019715.arc

251460  1    1       A 21-APR-13 /zone/dupdb/arch1/dupdb_1_1_813327814.arc

251467  1    2       A 21-APR-13 /zone/dupdb/arch1/dupdb_1_2_813327814.arc

251473  1    3       A 22-APR-13 /zone/dupdb/arch1/dupdb_1_3_813327814.arc

251485  1    4       A 22-APR-13 /zone/dupdb/arch1/dupdb_1_4_813327814.arc

deleted archive log

archive log filename=/zone/drprod/arch1/drprod_1_694_800019715.arc recid=4 stamp=813429204

deleted archive log

archive log filename=/zone/drprod/arch1/drprod_1_695_800019715.arc recid=5 stamp=813429204

deleted archive log

archive log filename=/zone/drprod/arch1/drprod_1_696_800019715.arc recid=6 stamp=813429204

deleted archive log

archive log filename=/zone/drprod/arch1/drprod_1_697_800019715.arc recid=7 stamp=813429204

deleted archive log

archive log filename=/zone/dupdb/arch1/dupdb_1_1_813327814.arc recid=1 stamp=813327994

deleted archive log

archive log filename=/zone/dupdb/arch1/dupdb_1_2_813327814.arc recid=2 stamp=813429138

deleted archive log

archive log filename=/zone/dupdb/arch1/dupdb_1_3_813327814.arc recid=3 stamp=813429201

deleted archive log

archive log filename=/zone/dupdb/arch1/dupdb_1_4_813327814.arc recid=8 stamp=813429283

Deleted 8 objects

database name is "DUPDB" and DBID is 3693079167

database dropped

database name is "DUPDB" and DBID is 3693079167

database unregistered from the recovery catalog

RMAN>

Alert.log will write the below logs

DROP DATABASE

Mon Apr 22 16:54:02 2013

Deleted file /u01/app/oracle/oradata/dupdb/system01.dbf

Deleted file /u01/app/oracle/oradata/dupdb/undotbs01.dbf

Deleted file /u01/app/oracle/oradata/dupdb/sysaux01.dbf

Deleted file /u01/app/oracle/oradata/dupdb/users

Deleted file /u01/app/oracle/oradata/dupdb/redo01.log

Deleted file /u01/app/oracle/oradata/dupdb/redo02.log

Deleted file /u01/app/oracle/oradata/dupdb/redo03.log

Deleted file /u01/app/oracle/oradata/dupdb/redo04.log

Instance terminated by USER, pid = 20258

Deleted file /u01/app/oracle/oradata/dupdb/control01.ctl

Deleted file /u01/app/oracle/oradata/dupdb/control02.ctl

Deleted file /u01/app/oracle/oradata/dupdb/control03.ctl

Completed: DROP DATABASE

Mon Apr 22 16:54:08 2013

Shutting down instance (abort)

License high water mark = 3