Re: (Easy?)Redolog question

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/21
Message-ID: <5gujt9$ce8@gw.PacBell.COM>#1/1

> 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............................;

did the SQL command you use to create the second member return w/o errors?

if so, then you probably did everything correct and just need to have the active redo cycle to the group with the second member. until that happens, the newly added second member is a "blank" redo log and thus INVALID.

if you don't feel like waiting, you can force the db to switch logfiles w/

alter system system switch logfile;

Johnny Chan
Independent Oracle Specialist Received on Fri Mar 21 1997 - 00:00:00 CST