Oracle 11g - DROP database command on ACFS

Question

In Oracle 11g and higher (on RHEL 6) issuing the 'drop database' command in mount restrict mode will delete all the DB's ASM datafiles. Can somebody tell me if this command also drops all ACFS datafiles? The documentation only says it's doesn't drop datafiles on raw devices.

Answer 1

And ACFS is not raw device, so the files will be deleted.

My ACFS:

[oracle@o6ca1 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@o6ca1 ~]$ acfsutil info fs /oradata
/oradata
 ACFS Version: 11.2.0.4.0
 flags: MountPoint,Available
 mount time: Wed Oct 31 15:21:46 2018
 volumes: 1
 total size: 10737418240
 total free: 8938848256
 primary volume: /dev/asm/oradata-379
 label:
 flags: Primary,Available,ADVM
 on-disk version: 39.0
 allocation unit: 4096
 major, minor: 247, 194049
 size: 10737418240
 free: 8938848256
 ADVM diskgroup DATA
 ADVM resize increment: 33554432
 ADVM redundancy: unprotected
 ADVM stripe columns: 4
 ADVM stripe width: 131072
 compatible.advm: 11.2.0.0.0
 number of snapshots: 0
 snapshot space usage: 0
 replication status: DISABLED

My database:

[oracle@o6ca1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? ORCL
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@o6ca1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 31 15:27:32 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/oradata/ORCL/users01.dbf
/oradata/ORCL/undotbs01.dbf
/oradata/ORCL/sysaux01.dbf
/oradata/ORCL/system01.dbf

Dropping the database:

SQL> startup force mount exclusive restrict
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2260088 bytes
Variable Size 335545224 bytes
Database Buffers 725614592 bytes
Redo Buffers 5517312 bytes
Database mounted.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> exit

Files are deleted:

[oracle@o6ca1 ~]$ ls -l /oradata/ORCL/
total 0

And the free space is also greater than it was before:

[oracle@o6ca1 ~]$ acfsutil info fs /oradata
/oradata
 ACFS Version: 11.2.0.4.0
 flags: MountPoint,Available
 mount time: Wed Oct 31 15:21:46 2018
 volumes: 1
 total size: 10737418240
 total free: 10579529728
 primary volume: /dev/asm/oradata-379
 label:
 flags: Primary,Available,ADVM
 on-disk version: 39.0
 allocation unit: 4096
 major, minor: 247, 194049
 size: 10737418240
 free: 10579529728
 ADVM diskgroup DATA
 ADVM resize increment: 33554432
 ADVM redundancy: unprotected
 ADVM stripe columns: 4
 ADVM stripe width: 131072
 compatible.advm: 11.2.0.0.0
 number of snapshots: 0
 snapshot space usage: 0
 replication status: DISABLED