Fw: Limiting RMAN backups-Please help

• Original Message ----- To: "Sona" <sona_us_at_hotmail.com> Sent: Thursday, February 14, 2002 9:20 AM

> You could move the file and change the entry in the recovery catalog, I
> quesss. I have never tried this so I'm not sure if it would work. The
> directory and name of the backupset piece is in rc_backup_piece.handle.
>
> HTH,
> Ruth
> ----- Original Message -----
> From: "Sona" <sona_us_at_hotmail.com>
> To: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> Sent: Wednesday, February 13, 2002 6:09 PM
> Subject: Re: Limiting RMAN backups-Please help
>
>
> > Thanks Ruth.
> > Can you tell me how to change the backup location.for e.g if I have
taken
> > backup at location /ora/backup and it is recorded the recovery catalog.
> Now
> > if I want to move the backup to /ora/backup1 .
> > How should i change it in the recovery catalog?
> >
> > TIA
> >
> >
> > ----- Original Message -----
> > From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> > To: "Sona" <sona_us_at_hotmail.com>
> > Sent: Wednesday, February 13, 2002 5:33 AM
> > Subject: Re: Limiting RMAN backups-Please help
> >
> >
> > > Exactly! I doesn't create extra backupsets but it creates them
faster.
> > > HTH, Ruth
> > > ----- Original Message -----
> > > From: "Sona" <sona_us_at_hotmail.com>
> > > To: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> > > Sent: Tuesday, February 12, 2002 4:19 PM
> > > Subject: Re: Limiting RMAN backups-Please help
> > >
> > >
> > > > Ruth,
> > > > Thanks for replying. Does using multiple channels but just one
backup
> > > space
> > > > parallelize the backup operation?
> > > >
> > > > Thanks
> > > > Sona
> > > >
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> > > > To: "Sona" <sona_us_at_hotmail.com>
> > > > Sent: Thursday, February 07, 2002 11:32 AM
> > > > Subject: Re: Limiting RMAN backups-Please help
> > > >
> > > >
> > > > > I only have one backup space and use two channels. It creates
files
> > of
> > > > only
> > > > > 2 gig on backup space. Rman takes care of all the underlying
stuff.
> > > > >
> > > > > Ruth
> > > > > ----- Original Message -----
> > > > > From: "Sona" <sona_us_at_hotmail.com>
> > > > > To: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> > > > > Sent: Thursday, February 07, 2002 2:19 PM
> > > > > Subject: Re: Limiting RMAN backups-Please help
> > > > >
> > > > >
> > > > > > Ruth,
> > > > > > Thanks fro your reply.
> > > > > >
> > > > > > This code will limit the size of each backup set to 2GB.Is there
> any
> > > way
> > > > > we
> > > > > > can limit the backup size in each of the volumes depending on
how
> > much
> > > > > space
> > > > > > is available in those volumes.
> > > > > >
> > > > > > For e.g if i want to limit
> > > > > > /disk1 to 40GB
> > > > > > /disk2 to 10GB
> > > > > > /disk3 to 10GB
> > > > > > /disk4 to 10Gb
> > > > > > I guess what i'm trying to do is the total size of the backup
> serts
> > > > going
> > > > > to
> > > > > > a particaluar location for e.g. /disk1 should be limited to
40GB.
> > > > > >
> > > > > > Can we do this?
> > > > > >
> > > > > > Also how do I paralleilize backups if I have only 1 backup
> > > destination.
> > > > > > For e.g if i have 2 channels with the same destination /disk1
then
> > > will
> > > > > the
> > > > > > 2 channels work in parallel or the paralllization happens only
if
> > the
> > > > > > destination is different.
> > > > > >
> > > > > > allocate channel c1 type disk format /disk1
> > > > > > allocate channel c2 type disk format /disk1
> > > > > > backup
> > > > > > archivelog all;
> > > > > >
> > > > > >
> > > > > > Will the backup happen in parallel or serial and will both the
> > > channels
> > > > do
> > > > > > the stuff?
> > > > > > The reason I'm asking this is because I did the backups of my
> > > > archivelogs
> > > > > > yesterday (about 15 GB) and it took about 50 --55 mins for the
> > > backup.I
> > > > > used
> > > > > > only one channel.
> > > > > > How do I parallelize this operation?
> > > > > >
> > > > > > Appreciate your help.
> > > > > >
> > > > > > Sona
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> > > > > > To: "Sona" <sona_us_at_hotmail.com>
> > > > > > Sent: Thursday, February 07, 2002 6:45 AM
> > > > > > Subject: Re: Limiting RMAN backups-Please help
> > > > > >
> > > > > >
> > > > > > > Here is the code I use to set the limit for each backup set to
2
> > > gig.
> > > > > It
> > > > > > is
> > > > > > > a limit on the channel(s). These code creates two channels for
> > > backups
> > > > > of
> > > > > > > our production database.
> > > > > > >
> > > > > > > replace script alloc_pa1_disk {
> > > > > > > #
> > > > > > > # Modified By Reason
> > > > > > > # 981002 rg created
> > > > > > > #
> > > > > > > allocate channel diskprdar201 type disk;
> > > > > > > setlimit channel diskprdar201 kbytes 2097150 maxopenfiles 4;
> > > > > > > allocate channel diskprdar202 type disk;
> > > > > > > setlimit channel diskprdar202 kbytes 2097150 maxopenfiles 4;
> > > > > > > }
> > > > > > >
> > > > > > > HTH,
> > > > > > > Ruth
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ----- Original Message -----
> > > > > > > From: "Sona" <sona_us_at_hotmail.com>
> > > > > > > To: <rgramolini_at_tax.state.vt.us>
> > > > > > > Sent: Wednesday, February 06, 2002 7:45 PM
> > > > > > > Subject: Limiting RMAN backups-Please help
> > > > > > >
> > > > > > >
> > > > > > > > Hi Ruth
> > > > > > > > I am doing RMAN incremental level 0 backup .The database
size
> is
> > > > about
> > > > > > > 150GB
> > > > > > > > out of which used would be about 100GB.I don't have a single
> > > volume
> > > > > with
> > > > > > > > 100GB of space.So I need to distribute the backup across
> several
> > > > > disks.
> > > > > > > >
> > > > > > > > Also I need to limit the backup size in each of the volumes
> > > > depending
> > > > > on
> > > > > > > how
> > > > > > > > much space is available in those volumes.
> > > > > > > > For e.g if i want to limit
> > > > > > > > /disk1 to 40GB
> > > > > > > > /disk2 to 10GB
> > > > > > > > /disk3 to 10GB
> > > > > > > > /disk4 to 10Gb
> > > > > > > > How would i do this in RMAN?
> > > > > > > >
> > > > > > > > TIA
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).