Re: (Easy?)Redolog question

From: Chris Kraft <ckraft_at_vines.etn.com>
Date: 1997/04/02
Message-ID: <33428CB5.175C@vines.etn.com>#1/1

theo.verbinnen_at_innet.be wrote:
>
> hi all,
>
> i'm trying to create a second member to an redolog group
> with the command alter database add logfile member 'filename'.
>
> no problem so far except that when a query the v$log file
> the status INVALID appears
>
> any help ? Thanks............................;

This is a normal responce from Oracle. When you add a logfile it is basicaly just invalid junk from the disk until Oracle comes around and starts using it.

If you really want to get rid of that message just use the command.

alter system switch logfile;

Do this until the system has used the logfile. You will find that the logfile is no longer invalid.

Chris Kraft Received on Wed Apr 02 1997 - 00:00:00 CST