no lightening bolt, remind me not to post things after lunch...
the database will appear to hang. you like that phrasing better? :)
If you cycle around in the redo logs to the point where Oracle would
have to overwrite an unarchived log, no one can log into the database
and most processes will stop, waiting for the log to be archived.
- Daniel Fink <daniel.fink_at_sun.com> wrote:
> As much as I hate to disagree with the DBA Goddess...
> The database will not HANG. A more appropriate term is that further
> processing is halted until it is able to archive the redo log before
> it begins to overwrite it.
> You will receive a message in the alert log, I don't recall the exact
> text, but it is along the lines of archiver stuck or unable to
> archive a log.
>
> <waiting for the lightning bolt...>
>
> Rachel Carmichael wrote:
> >
> > Yes you have to move them to tape and either compress or delete
> them
> > once you have backed up the logs and datafiles.... Check out the
> > Backup and Recovery Handbook by Velpuri, there are some pretty good
> > examples there.
> >
> > If you don't clean out the archive directory on occasion, the
> database
> > will hang when that filesystem is filled. you won't get a message
> that
> > it's hung but it will hang.> begin:vcard
> n:Fink;Daniel
> tel;cell:303.808.3282
> tel;work:303.272.3225
> x-mozilla-html:TRUE
> adr:;;;;;;
> version:2.1
> email;internet:daniel.fink_at_sun.com
> title:DB Services Lead
> x-mozilla-cpt:;-4832
> fn:Daniel Fink
> end:vcard
>
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Received on Wed Jul 23 2003 - 14:16:30 CDT