Re: archivelog leads to crashes...?

"Ronald Rood" <devnull_at_ronr.nl> wrote in message news:0001HW.BC7BBAD603E24E13F02845B0_at_news.individual.net...
> On Mon, 15 Mar 2004 19:51:00 +0100, Andrew Metcalfe wrote
> (in message <a2588ec3.0403151051.749478bf_at_posting.google.com>):
>
> > Last night I started a project to get hot backups working on my 8.1.7
> > production server.
> >
> > After setting the database to archivelog, the instance would crash and
> > refuse connections. I found the following in my alert.log file:
> >

--snip--
> > Thread 1 cannot allocate new log, sequence 47261
> > All online logs needed archiving
> > Current log# 1 seq# 47260 mem# 0: E:\ORACLE\ORADATA\DB\REDO01.LOG
> > Mon Mar 15 00:39:12 2004
> > Shutting down instance (immediate)
> >
> > Looking online, the culprit here is usually disk space. I have plenty
> > of disk space on all disks on this server... so its not disk space.
> > E: is a single fast large physical disk without any RAID.
> >
> > These are the steps I used to enable archivelog.
> >
> > svrmgrl
> >
> > connect internal
> >
> > shutdown immediate
> >
> > startup mount
> >
> > alter database archivelog;
> >
> > alter database open;
> >
> > Everything appeared to work properly. Upon completion, I could
> > immediately connect, but after a very brief period I could no longer
> > connect and my applications would hang.
> >
> > My intention is to use the Management Console to schedule nightly
> > backups, but I haven't done that yet.
> >
> > _Am
>
> How about
> alter system archivelog start;
>
>
> --
> With kind regards,
> Ronald
> http://ronr.nl/unix-dba
>

and .. how about putting this in the init.ora also. LOG_ARCHIVE_START=TRUE and rtfm:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/archredo.htm#4718

Anurag Received on Mon Mar 15 2004 - 13:04:54 CST