Automatic archival off causes the database to hang when the redo log that
oracle needs to switch into is unavailable because it needs archival.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Mo" <ranamo_at_mailbox.bellatlantic.net> wrote in message
news:3A78A569.8671A275_at_mailbox.bellatlantic.net...
> Hi Jonathan
>
> Yes, I have archive logging on, but not sure about automatic archival off.
> (I'll check it tomorow)
>
> How to check for it anyway?
> and why this automatic archival off cause the hanging on creating tables
> and I even got the system hang in the middle of Import and nothing work
until
> the database was shutdown and restarted.
>
> Thanks
> Mo
>
> > Is it possible you have archive logging on,
> > but automatic archival off ?
> >
> > Any hints from messages in your alert log ?
> >
> > --
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Practical Oracle 8i: Building Efficient Databases
> >
> > Publishers: Addison-Wesley
> > More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
> >
> > MAbbouchi_at_IITRI.ORG wrote in message ...
> > >Installed Oracle 8.1.7 a month ago and it still unstable.
> > >
> > >Today, when I try to create a table from DBA studio or SQL PLUS it just
> > >hang, until closing it.
> > >
> > >I went to the server to shut down the instance from the DBA studio and
it
> > >also hang with nothing else
> > >can be done except killing it, then I started the instance back and I
was
> > >able to shutdown normally
> > >then start again with no problems.
> > >
> > >what could be causing this problem??
> > >
> > >is there a patch for 8.1.7 release yet???
> > >
> > >Thanks
> > >Mo
> > >
> > >--
> > >Posted from nat05.IITRI.ORG [205.167.170.5]
> > >via Mailgate.ORG Server - http://www.Mailgate.ORG
>
Received on Thu Feb 01 2001 - 03:34:07 CST
