RE: ACTIVE STATUS in v$log

> Emine / List,

i dont have any checkpoint not complete messages..., however i tried a "alter system checkpoint" and the ACTIVE status turned to INACTIVE.
so, you are right that the log was waiting for the checkpoint.. meaning the DB is having
checkpoints at log switch only... (i need to verify this )

regards

PS: "required for crash recovery" (status ACTIVE) means that if the instance crashes,
it would require that log (the only online redo log ) for the media recovery ? apart from the
archived ones

> ----------
> From: Emine ATES[SMTP:emineates_at_postmaster.co.uk ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, December 22, 2000 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ACTIVE STATUS in v$log
>
> Dear Rahul,
> did you check the alert.log for
> 'checkpoint not complete' messages?
> Acc. to my knowledge,
> archiver is fired on the event of log switch but it doesn't
> wait for LGWR to complete the checkpoint.If checkpoint can not be
> completed, that log remains active and required for
> crash recovery, therefore at sometime a log can be both
> active and archived.
> I don't know much about your standby db status but if
> a crash occurs at this critical point I had to make a recovery.
> Please correct me if I'm in conflict.
> Emine.
> On Thu, 21 Dec 2000 20:25:33 -0800 Rahul <rahul_at_ratelindo.co.id> wrote:
> > List,
> > metalink explaing the ACTIVE value in STATUS columns of v$log as ..
> >
> > x-------x-----------x----------x------------x
> > ACTIVE indicate 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.
> > x-------x-----------x----------x------------x
> >
> > i have three groups (2 member each) and at any given time one of the
> > group status is ACTIVE, it remains active untill the next group in
> sequence
> > is archived , and then, the group just archived becomes ACTIVE !!
> >
> > why the log is ACTIVE when it's archived status is YES ? and the log has
>
> > been successfully applied to the standby also !
> >
> > Regards
> >
> > Rahul
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Emine ATES
> INET: emineates_at_postmaster.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Fri Dec 22 2000 - 03:29:19 CST