I believe that if the database is "hung" because of the archiver unable to write because of the lack of disk space, you can still connect using the svrmgr. It at least gives you a method of snooping around of your alert log doesn't point to the problem. Ron
>>> [EMAIL PROTECTED] 07/23/03 04:14PM >>> 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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 http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).