Re: Oracle Doc Error

Thank you Paul for your reply. I should first give a bit more details on my setup: I don't use archivelog (this is only my "toy" laptop database), and I don't multiplex my redo logs either. I don't fully understand your comments about the control returning to the user. It seems to me that if I issue "alter system checkpoint", the control will return after the checkpoint completed, and if I issue "alter system switch logfile", the control returns after the switch occurred. As far as I understand, a log switch is independant of a checkpoint (one doesn't imply the other). I therefore think that Oracle should say that a checkpoint (not a log switch) is necessary before a redo log drop can happen.

Daniel

>
> I believe that "alter system switch logfile;" returns control to the
> calling process/thread immediately.
>
> Try issuing the checkpoint first and repeat.
>
> I believe that "alter system checkpoint;" does not return control to
> the calling process/thread immediately.
>
> That would describe the behavior you are experiencing.
>
> See, the value in the column "STATUS" is active.
> That implies that the log is still being archived.
> Check in v$archived_log for when that log has been archived.
> (you may want to set your nls_date_format to something that has a
> resolution in seconds, such as "alter session set
> nls_date_format='RRRRMMDD HH24:MI:SS';".
>
> Multiplex your redo logs, so that if one file is hosed, your stream of
> archived redo logs is not interrupted. I can't tell if the log groups
> have more than one member, as you only displayed the output from
> v$log, not v$logfile.
>
> hth.
>
> Pd
Received on Thu Jan 22 2004 - 20:03:15 CST