Re: Archive mode

Do you have automatic archiving enabled. This is done via LOG_ARCHIVE_START=TRUE in your init.ora. If this is not enabled, Oracle will wait until you manually archive. Believe it or not, the default is FALSE.

Ciaran

CME Systems wrote:

> Thanks for the speedy response but the disk has 1.4gb of free space, is
> there any way I can stop the thing running without causing any problems?
> Thanks
> Andy
>
> harronc_at_attglobal.net wrote in message <39F7F68C.AFA07E27_at_attglobal.net>...
> >It probably means that the archive log directory is full.
> >
> >Ciaran
> >
> >CME Systems wrote:
> >
> >> All
> >> Just a quickie honest. I have set the database to archive mode and
 was
> >> working away when it suddenly ground to a halt. The server is now
 churnning
> >> away but nothing is happening. The response from Oracle is as if it has
> >> hung. I have gone int svrmgr and tried to shutdown but it to gives the
> >> appearance of it hanging. Is this the archiving process taking place and
 if
> >> so is there any way to suspend it or speed it up?
> >> Thanks in advance
> >> Andy Lovegrove
> >
> >
> >
> >

--
Ciaran Harron
Logica
Senior Consultant
Solutions, Telecoms, Asia
tel: +6221 526-4702
mobile: +62811 987348
fax: +6221 252-5760
http://www.logica.com