Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! 9i hosed!

Re: Help! 9i hosed!

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 26 Aug 2005 20:13:57 +0200
Message-ID: <denm55$d4m$2@nntp.fujitsu-siemens.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US