Re: Help! Archiver failed! Need guidelines please.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 30 Dec 2003 20:09:40 +0100
Message-ID: <46j3vvco1ndsdkvvtdhq9g36bopsivdqkf@4ax.com>

On 30 Dec 2003 10:47:44 -0800, klist_at_adnohr.net (Al) wrote:

>Gurus,
>
>Are there guidelines to determine the necessary size to allocate to a
>disk
>device that contains my log archive?
>
>My Unix sysadmin got the message "Critical Disk Near Full!"...for the
>3rd time this week.
>
>Select archiver from v$instance came back with FAILED. So I did
>"alter
>system archive log stop;". This is a production datamart for which I
>have
>not had any hot/cold backup for 3 weeks. I am worried.
>
>The overall size of my production datamart is 190GB. My archive log is
>about 29 GB in size at the moment.
>
>I am running v9.2 on HP-UX B.11.00 U 9000/800.
>
>TIA for any help you can provide.
>
>kl.

The guideline is you need as much disk capacity to hold all the archive logs between 2 backups. After making a backup (during which you backup the archive logs) you can delete the archive logs. Of course you can make backups of archive logs in between those database backups.

The size you need can be determined from v$log_history.

From what I read here your backup strategy looks insufficient to me.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 30 2003 - 13:09:40 CST