How to Drop a Redo Log File ?

Answer > Connect to the Oracle database and execute the following SQL statements :

First, check that which REDO log file is INACTIVE by executing the following statement.

select group#, status, bytes/1024/1024 from V$log;


Now, you may drop a logfile which is INACTIVE.

alter database drop logfile group 1;                                                   ---For dropping group 1 logfile.

After dropping the logfile, remove the entry of the logfile(e.g. REDO01) from the location at which you created the logfile if you want to create a logfile with the same name in future.

'E:\APP\ORACLE\ORADATA\PKT009\REDO01.LOG'

Cheers!!!