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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Setting the archive destination

Re: Setting the archive destination

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 15 Jun 2000 11:20:25 -0400
Message-Id: <10529.109422@fatcity.com>


You can run the archive log backup by itself and compress the backupsets as they finish. Ruth
----- Original Message -----
From: <Lisa_Koivu_at_gelco.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, June 15, 2000 9:54 AM
Subject: 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)
>
>
>
>
> 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
> (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
Received on Thu Jun 15 2000 - 10:20:25 CDT

Original text of this message

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