topic Re: archive log dir is full ,how can I deal it ? in Operating System - HP-UX

archive log dir is full ,how can I deal it ?

xiongye_2 — Tue, 16 Jul 2002 04:48:06 GMT

Hi: I executed a stored procedure last night,
today i find that the archive log is full, I use rm to del all trc file. Shutdown DB and turn the database into noarchive log mode,
but it is not the right method, Can you tell me the right one?

Re: archive log dir is full ,how can I deal it ?

steven Burgess_2 — Tue, 16 Jul 2002 05:08:34 GMT

Hi

Have a look at the attached script which we run to clear our ora_archive logs

HTH

Steve

Re: archive log dir is full ,how can I deal it ?

Brian Crabtree — Tue, 16 Jul 2002 21:27:34 GMT

Archive logs are worthless unless you are taking online backups. Otherwise, you should back the archivelogs up to tape for recoverability. Most DBA's try to keep least 1 day on disk, however this would depend on how many logs you are creating each day.

Brian

Re: archive log dir is full ,how can I deal it ?

Jeanine Kone — Tue, 16 Jul 2002 21:56:37 GMT

I would suggest having a script that copies the archive logs to tape and then deletes them. The frequency with which you do this will depend upon how many logs you go through per day. I have my script running every 2 hours. Even if you have the disk space I would still back them up to tape at least once per day - you will need them to recover your database, and the ones on disk may not be accessible.

Re: archive log dir is full ,how can I deal it ?

Dave Chamberlin — Tue, 16 Jul 2002 22:11:54 GMT

I use a script each night to move the archive logs to a non-oracle disk (that has lots of space). We generate about 5G of redo on the avg day. This is the pre-exec script for an omniback backup, which then backs the logs up to tape each night. The script removes old logs from that directory before moving the new ones in. the logs must be kept back to the last full hot or cold backup to be of use if the database needs recovery.

Re: archive log dir is full ,how can I deal it ?

James George_1 — Wed, 17 Jul 2002 14:27:04 GMT

Hi

If you have a backup software,
configure an archive backup which will take the archives in to a tape and then delete the archive logs.

James