Jul 21
eg:
1. alter database drop logfile group 1;
2. alter database add logfile group 1 (
‘/u01/oralog/redo01a.log’,
‘/u02/oralog/redo01b.log’) size 250m reuse;
that’s it. Keep in mind that it’s not possible to drop the “CURRENT” log group (switch to another redo log group with: alter system switch logfile). If the status of the log group you want to recreate is “ACTIVE” then perform a global checkpoint (alter system checkpoint global).
Taken from: http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_34.shtml
