Oracle 通过drop database命令删除数据库

如果使用DROP DATABASE 命令删除ORACLE实例：


oracle@oracle /home/oracle$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on 星期五 11月 27 09:33:56 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ora (DBID=3396660760)

RMAN> startup force mount

Oracle instance started

database mounted

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes

Variable Size               1862272184 bytes

Database Buffers            2399141888 bytes

Redo Buffers                  12132352 bytes

RMAN> sql 'alter system enable restricted session';

using target database control file instead of recovery catalog

sql statement: alter system enable restricted session

RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;

database name is "ora" and DBID is 3396660760

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=760 device type=DISK

specification does not match any backup in the repository

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=760 device type=DISK

specification does not match any datafile copy in the repository

specification does not match any control file copy in the repository

specification does not match any control file copy in the repository

List of Archived Log Copies for database with db_unique_name ora

=====================================================================

Key     Thrd Seq     S Low Time           

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

30      1    36      A 2015-11-12 00:02:02

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_36_c4bmrx7w_.arc

31      1    37      A 2015-11-13 10:46:53

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_37_c4bop494_.arc

32      1    38      A 2015-11-13 11:19:32

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_38_c4botcrx_.arc

33      1    39      A 2015-11-13 11:21:47

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_39_c4bp3hdw_.arc

34      1    40      A 2015-11-13 11:26:39

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_40_c4cbw4gr_.arc

35      1    41      A 2015-11-13 17:21:08

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_41_c4cbzbrn_.arc

36      1    42      A 2015-11-13 17:22:50

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_42_c4cdbwfm_.arc

37      1    43      A 2015-11-13 17:46:04

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_43_c4cdh9vk_.arc

38      1    44      A 2015-11-13 17:48:25

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_44_c4cdwkbw_.arc

39      1    45      A 2015-11-13 17:55:29

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_14/o1_mf_1_45_c4dy9hyg_.arc

40      1    46      A 2015-11-14 07:58:39

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_16/o1_mf_1_46_c4mvlocp_.arc

41      1    47      A 2015-11-16 22:55:17

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_19/o1_mf_1_47_c4tgv19l_.arc

42      1    48      A 2015-11-19 11:00:49

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_48_c506njr6_.arc

43      1    49      A 2015-11-21 15:17:36

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_49_c506onq1_.arc

44      1    50      A 2015-11-21 15:18:12

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_50_c506opsy_.arc

45      1    51      A 2015-11-21 15:18:14

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_51_c506oqyz_.arc

46      1    52      A 2015-11-21 15:18:15

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_24/o1_mf_1_52_c56g067w_.arc

47      1    53      A 2015-11-24 00:00:06

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_26/o1_mf_1_53_c5dmjz8x_.arc

48      1    54      A 2015-11-26 08:11:11

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_26/o1_mf_1_54_c5g9yt9x_.arc

49      1    55      A 2015-11-26 23:40:10

        Name: /opt/oracle/fast_recovery_area/ora/archivelog/2015_11_27/o1_mf_1_55_c5hdq54x_.arc

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_36_c4bmrx7w_.arc RECID=30 STAMP=895661216

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_37_c4bop494_.arc RECID=31 STAMP=895663175

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_38_c4botcrx_.arc RECID=32 STAMP=895663311

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_39_c4bp3hdw_.arc RECID=33 STAMP=895663602

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_40_c4cbw4gr_.arc RECID=34 STAMP=895684871

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_41_c4cbzbrn_.arc RECID=35 STAMP=895684973

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_42_c4cdbwfm_.arc RECID=36 STAMP=895686367

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_43_c4cdh9vk_.arc RECID=37 STAMP=895686508

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_13/o1_mf_1_44_c4cdwkbw_.arc RECID=38 STAMP=895686932

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_14/o1_mf_1_45_c4dy9hyg_.arc RECID=39 STAMP=895737522

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_16/o1_mf_1_46_c4mvlocp_.arc RECID=40 STAMP=895964120

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_19/o1_mf_1_47_c4tgv19l_.arc RECID=41 STAMP=896180452

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_48_c506njr6_.arc RECID=42 STAMP=896368659

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_49_c506onq1_.arc RECID=43 STAMP=896368692

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_50_c506opsy_.arc RECID=44 STAMP=896368694

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_21/o1_mf_1_51_c506oqyz_.arc RECID=45 STAMP=896368696

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_24/o1_mf_1_52_c56g067w_.arc RECID=46 STAMP=896572809

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_26/o1_mf_1_53_c5dmjz8x_.arc RECID=47 STAMP=896775074

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_26/o1_mf_1_54_c5g9yt9x_.arc RECID=48 STAMP=896830812

deleted archived log

archived log file name=/opt/oracle/fast_recovery_area/ora/archivelog/2015_11_27/o1_mf_1_55_c5hdq54x_.arc RECID=49 STAMP=896866405

Deleted 20 objects

database name is "ora" and DBID is 3396660760

database dropped

RMAN> 


查看alter.log信息：
DROP DATABASE
Deleted file /opt/oracle/oradata/ora/system01.dbf
Deleted file /opt/oracle/oradata/ora/sysaux01.dbf
Deleted file /opt/oracle/oradata/ora/undotbs01.dbf
Deleted file /opt/oracle/oradata/ora/users01.dbf
Deleted file /opt/oracle/oradata/ora/mgmt_ecm_depot1.dbf
Deleted file /opt/oracle/oradata/ora/mgmt.dbf
Deleted file /opt/oracle/oradata/ora/mgmt_ad4j.dbf
Deleted file /opt/oracle/oradata/ora/redo01.log
Deleted file /opt/oracle/oradata/ora/redo02.log
Deleted file /opt/oracle/oradata/ora/redo03.log
Deleted file /opt/oracle/oradata/ora/temp01.dbf
Deleted file /opt/oracle/product/11.2.0/db_64/dbs/snapcf_oemcloud.f
Shutting down archive processes
Archiving is disabled

参考：