RE: Setting the archive destination

Thanks for your response.

Unfortunately I am not convinced it's that simple.

They finally gave me the extra space I was asking for yesterday when everything ground to a halt - there were ~150 arc files to be backed up. At peak processing they generate one 100M arc file every 1-2 minutes. I see no way around this. So they generate ~5GB an hour, and a tape backup job to write this much data can take three hours. I have tried bumping up the frequency of the rman jobs, but they seem to step on each other and screw each other up (NetBackup is our lovely backup software). Add to it one of the tape drives may be on the fritz and it's very difficult to tell which one it is, per our SA. So jobs die just for the heck of it.

I had jobs running every 15 min during peak processing - Didn't help. I had 12 jobs sitting out there at one time fighting for resources. The best frequency I've found is once an hour. And with the space I now have, I think I'm in good shape at least until I leave at the end of the month, and I can now sleep at night and do things other than babysit backups during the day.

A big dirty martini helped me get over this fiasco.

Thanks
Lisa
Minneapolis,MN,USA

ddorr.cs_at_clearstream.com on 06/15/2000 05:00:49 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: RE: Setting the archive destination

I think the solution may be elsewhere.
If your arch directory fills so quickly that RMAN does not have time to back it up, it may be time to enlarge this filesystem, or compress archived redologs if not already done.
If RMAN does not run often enough (eg, you run RMAN once a day, but sometimes extra activity generates more redo and your archive dir fills up), then you can run regularly (via cron) a shell script than monitors the free space in this dir and launches an extra RMAN session (wich will only backup the archives ) if needed.

> ----------
> From: Lisa_Koivu_at_gelco.com[SMTP:Lisa_Koivu_at_gelco.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, June 14, 2000 22:33
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Setting the archive destination
>
> Will doing this possibly mess with a currently running RMAN job?
> This happens so frequently I could scream: My arc destination fills up
> and I
> have to manually fiddle with the backups, and move files not included in
> the
> current backup elsewhere until the current backup completes. Then I move
> the
> arclogs back to the arc dest and start another backup. Would issuing this
> command at the command line confuse the currently running RMAN job?
>
> I'm dealing with this right now. Once I get out of this mess I will try
> it out.
>
> Thanks in advance for any suggestions
> Lisa
>
>
>
>
>
> dgoulet_at_vicr.com on 06/14/2000 10:55:32 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Lisa Koivu/GELCO)
>
>
>
>
> alter system archivelog start to <wherever>
>
> ____________________Reply Separator____________________
> Author: Linda Hagedorn <Linda_at_pets.com>
> Date: 6/13/00 1:13 PM
>
> Hello,
>
> Is there a way to set the archive destination on a system which is
> running,
> or will I have to change the config file and shutdown/startup the
> database?
>
> Thanks, Linda
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author:
  INET: ddorr.cs_at_clearstream.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L