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

Home -> Community -> Usenet -> c.d.o.server -> Why the newly added logfile member is always invalid?

Why the newly added logfile member is always invalid?

From: <hope_smith_at_hotmail.com>
Date: Wed, 09 Sep 1998 19:57:39 GMT
Message-ID: <6t6mji$5jr$1@nnrp1.dejanews.com>


Using Personal Orackle 8.0.3

Startup database with mount only.
Add logfile member to the existing group.

Check the v$logfile.
 The status of the newly added logfile member is always marked as INVALID no  matter whether the group is active or not.

 I have to use
 alter system clear unarchieved logfile group #  to make it valid before use it. But I know it will bring trouble for recovery  later.

 Is there anything wrong I did or is there any better solution?

 Thanks.

 Hope
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 09 1998 - 14:57:39 CDT

Original text of this message

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