Re: Managing Archived Redo Logs

Hi!

You actually can connect using sqlplus as well, even over the network, as long as your connection is sysdba (or probably sysoper as well).

There's several more interesting issues with sysdba connections, for example if you got a bad after logon trigger which throws unhandled exceptions, regular users can't logon, but sysdba can (actually it comes from administer database trigger privilege), but the idea is that the database can behave quite differently for privileged users..

Tanel.

• Original Message ----- From: "Ron Rogers" <RROGERS_at_galottery.org> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 24, 2003 12:24 AM Subject: Re: Managing Archived Redo Logs

> 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
>
> >>> wisernet100_at_yahoo.com 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 <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
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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: 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
Received on Wed Jul 23 2003 - 16:43:12 CDT