none wrote:
> 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
>
Somehow I miss an open resetlogs here.
Am I wrong?
Lots of Greetings!
Volker
Received on Fri Aug 26 2005 - 13:13:57 CDT
