DB version: 11.2.0.4
OS : RHEL 7.3
In my standalone DB which uses Linux Filesystem to store DB files, I have dropped the following redo log groups from DB level.
But, the file still exists at the OS level. This is expected behaviour. Right ? I can manually remove these files using rm command. Right ?
SQL> select l.thread# inst, l.group#, l.SEQUENCE#, lf.member,
l.status, l.archived, l.bytes/power(1024,3) sizeGB
from v$log l , v$logfile lf
where l.group# = lf.group#
order by 1,2; 2 3 4 5
INST GROUP# SEQUENCE# MEMBER STATUS ARC SIZEGB
---------- ---------- ---------- ---------------------------------------------------------- ---------------- --- ----------
1 2 2 /oradata/FTCPRD/OnlineRedoLog/redo02.log INACTIVE NO .48828125
3 3 /oradata/FTCPRD/OnlineRedoLog/redo03.log INACTIVE NO .48828125
4 4 /oradata/FTCPRD/OnlineRedoLog/redo4a.log CURRENT NO .48828125
4 /data1/FTCPRD/OnlineRedoLog/redo4b.log CURRENT NO .48828125
5 0 /oradata/FTCPRD/OnlineRedoLog/redo5a.log UNUSED YES .48828125
0 /data1/FTCPRD/OnlineRedoLog/redo5b.log UNUSED YES .48828125
6 0 /oradata/FTCPRD/OnlineRedoLog/redo6a.log UNUSED YES .48828125
0 /data1/FTCPRD/OnlineRedoLog/redo6b.log UNUSED YES .48828125
8 rows selected.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$
$ ls -lh /oradata/FTCPRD/OnlineRedoLog/redo02.log
-rw-r-----. 1 oracle oinstall 501M Jun 8 12:49 /oradata/FTCPRD/OnlineRedoLog/redo02.log