Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to restart an instance who failed in lack of archivelog space ?

Re: How to restart an instance who failed in lack of archivelog space ?

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Mon, 22 Apr 2002 22:58:25 GMT
Message-ID: <lA0x8.40836$Rw2.3129518@bgtnsc05-news.ops.worldnet.att.net>


Frederic, that's one good reason to keep track of your archivelog directories as you discovered.

The quickest instant fix is to use the UNIX mv command to get the archived redos out of there, and then the database should resume operation by itself.

But a nicer process would be to periodically run a process like this, substituting whatever you have chosen as your extent for archived redo logs for .arc:

find . -name \*.arc | compress -vc {} > /blah/oracle/zfiles \;

or, depending on space available etc and how active things are you could run "in situ",

find . -exec compress -v {}

and then have another process to copy and verify the resulting Z files to a separate place.

In situ compression of the archived logs works pretty well if you do it frequently enough; typically you can expect at least a 5 to 1 reduction in file size. If your redo logs are very large, and you do not have enough free space in your archived redo log directory to store the working copy of the file under compression, then that's not good.

In an ideal world, your process should compress while copying elsewhere, ensure that the copy is valid, delete the original logfile, etc.

But if your database is halted due to archived redo log clog, just move the damn things anyplace safe you can find, and deal with the rest afterwards.

RSH. "Frederic Payant" <fpayant_at_club-internet.fr> wrote in message news:60r8cucakcdshnrfusddq55ft9g7t836g1_at_4ax.com...
> Hi,
>
> Is there any way to restart an instance when it freezed
> because of lack of space in archive log directory ?
> It seems that shutdown and restart is the only way for it to
> work again even if free space is allocated in archive log dir.
>
> Thanks
> Regards
> Frederic PAYANT - junior DBA ;-)
Received on Mon Apr 22 2002 - 17:58:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US