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).
Received on Fri Dec 22 2000 - 03:08:30 CST
