Re: ** v$log.status

There is a pretty good explanation in this usenet thread:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=OoSWa.122%246d2.89%40newssvr22.news.prodigy.com&rnum=1&prev=/groups%3Fq%3Dv%2524log.status%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DOoSWa.122%25246d2.89%2540newssvr22.news.prodigy.com%26rnum%3D1

Regards,
Dave

ajoshi977_at_yahoo.com wrote:

> Hi,
> In view v$log there is a column status. This changes from current
> (if the redo log is in use) to atcive then to inactive. Documentation
> says :
>
> # ACTIVE: The log is active but is not the current log. It is needed for
> crash recovery. It may be in use for block recovery. It might or might
> not be archived.
> # INACTIVE: The log is no longer needed for instance recovery. It may be
> in use for media recovery. It might or might not be archived.
>
> So if it is in 'ACTIVE' status : it means it is needed for
> crash/instance recovery? So what does it mean? That changes in this
> log are still not written to data files? What else? Is this related to
> delayed block cleanout etc or no connection?
>
> What factor affects how long it will be in ACTIVE state before going
> to INACTIVE? What can be changed to control how long it takes. Any
> trade off?
>
> Any detailed explanation on this will be greatly appreciated. You can
> mail me direct or to the list. Thank you.
>
>
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> <http://us.rd.yahoo.com/evt=21608/*http://webhosting.yahoo.com/ps/sb/>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Hau
  INET: davehau123_at_netscape.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).