KK

• May 16th, 2006

 

           You cannot drop a current online redo log file group or a member of it. In order to drop the current online redo log file member,you must force a log switch using ALTER SYSTEM command as follows:

           Sql > ALTER SYSTEM SWITCH LOGFILE;

           Then the online redo log file group will be active and if you again force a log switch,you will see that the redo log file group will be inactive.Now you can drop the redo log member.so, you cannot drop a redo log group or member when it is in current or active status.

Mohammed Abdul Afroze

• Oct 31st, 2007

 

To drop an current online redo log file group.

1.Switch the logfile.

sql>Alter system switch logfile;

It will change the status from current to active.Switch the logfile once again.The status will be inactive.Now u can drop it.

sql>alter system switch logfile;
sql>alter database drop logfile group 1;