Re: Archivelog Mode Questions

> chuckh_at_dvol.com (Chuck Hamilton) writes:
> bjonnard_at_ix.netcom.com (Bill Jonnard) wrote:
>
> >In other words, if I have accumulated 20 archive logs, Oracle will
> >apply them one by one without any problems, but will always end up
> >asking for file #21. As I stated above, I only had 20 to start with.
> >The maddening result of this is that instead of seeing a "Recovery
> >Successfully completed" type of message, I get an error message
> >telling me that I need one more (nonexistent) archive log file. Does
> >anyone have an idea as to why this is happening and how I can avoid
> >it?

It sounds to me like ORACLE was up, or didn't finish its shutdown, when you did a cold backup -- or started up before your backup was done. So it thinks you did a hot backup and is looking for before-images to "focus" a "fuzzy" restored datafile, whether or not it really needs them. At any rate this happened to me once and that was Oracle Suppport's explanation. Ideally your backup run should be set up as a single job which does a shutdown immediate, then the operating system backup, then a startup; this arrangement keeps the three events from overlapping. We use shutdown immediate to keep the shutdown from hanging indefinitely on somebody's idle terminal; it rolls back any uncompleted transactions and forces a disconnect.

• Paul de Anguera City of Seattle / HRIS