Re: Add log group member??!!

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Wed, 26 May 1999 13:56:57 -0400
Message-ID: <374c35dc.0@news.mountain.net>

To further expand on the previous answer, there are 3 possible values for status:

<null>, invalid or stale.

<null> - Everything is fine and logfile is ok. invalid - If you just created the logfile then Oracle will mark the new one as invalid until the

                system does enough log switches to cycle back through and
reset that log file so that
                all members of the group are in sync.  After the log
switches cycle back around, if
                the log member is still invalid you need to look at the

alert log, you have a problem.
stale - Usually only seen when a log group or database is new. It just means Oracle has not

                visited that logfile yet to see if it is good.

Kenny Gump
OCP 7.3 DBA Jack Zhu wrote in message <7if9qf$phs$1_at_news.monmouth.com>...
>1. startup mount
>2. alter database add logfile member 'file-name' to group 4;
>3. alter database open;
>
>Then I check v$logfile, it shows the status of the new log file is
>'invalid'. (Oracle 8.0.5 for NT)
>
>What does it mean? Anything wrong?
>
>How many different values in this 'status' column? what's the meaning of
>them?
>
>Thanks a lot!!
>
>Pls email me.
>
>jackzhu_at_monmouth.com
>
>
>
Received on Wed May 26 1999 - 12:56:57 CDT