Re: Help! Archiver failed! Need guidelines please.

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<46j3vvco1ndsdkvvtdhq9g36bopsivdqkf_at_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.

I could not agree more. I don't have a backup strategy (that's obviously the problem): my datamart is suffering of the "too many chiefs, not enough indians" syndrome. Get the picture?

I am a database developer who's trying very hard to have a stable environment to write my SPs, shell scripts and deliver my reports to my users. And the acting DBA can't get bothered with my questions...

Sorry for the rant. Thanks a millions for your answers. Received on Wed Dec 31 2003 - 13:00:37 CST