Re: Help! 9i hosed!

Here is the fix:

DB must be MOUNTED, not OPEN.

SQL> alter database drop logfile group 2; SQL> alter database add logfile group 2
('C:\ORACLE\ORADATA\HYDRO\REDO02.LOG') size 100M;
SQL> alter database drop logfile group 3; SQL> alter database add logfile group 3
('C:\ORACLE\ORADATA\HYDRO\REDO03.LOG') size 100M;
SQL> select * from v$log; -- check the status of new ones will be UNUSED

SQL> alter database open;
SQL> alter system switch logfile;
SQL> select * from v$log;  -- check that the CURRENT group is changed