RMAN

Hi,

We're setting up RMAN and configuring our environment. We are on
Oracle 10gR2. I'm having trouble understand these commands:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
PARALLELISM 20;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';


They both specify disk. But, can they be combined into one command?
The documentation is really not specific on this. They show different
variants of the above, but I did not find anything on a combination of
the commands. If we can do it in one command, it makes more
sense......

Thank you.

On Aug 27, 1:19 pm, artme...@yahoo.com wrote:
> Hi,
>
> We're setting up RMAN and configuring our environment. We are on
> Oracle 10gR2. I'm having trouble understand these commands:
>
> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> PARALLELISM 20;
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';
>
> They both specify disk. But, can they be combined into one command?
> The documentation is really not specific on this. They show different
> variants of the above, but I did not find anything on a combination of
> the commands. If we can do it in one command, it makes more
> sense......
>
> Thank you.

Sorry for the double post, but as we are reading and seeing BACKUPSET
and BACKUPPIECE........we can see that a piece is part of a set. But,
if you need to break up the set into pieces, why not just make smaller
size sets??

We're all new to this.....

Thank you

On Aug 27, 1:19 pm, artme...@yahoo.com wrote:
> Hi,
>
> We're setting up RMAN and configuring our environment. We are on
> Oracle 10gR2. I'm having trouble understand these commands:
>
> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> PARALLELISM 20;
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';
>
> They both specify disk. But, can they be combined into one command?
> The documentation is really not specific on this. They show different
> variants of the above, but I did not find anything on a combination of
> the commands. If we can do it in one command, it makes more
> sense......
>
> Thank you.


Sorry for the double post, but as we are reading and seeing BACKUPSET
and BACKUPPIECE........we can see that a piece is part of a set. But,
if you need to break up the set into pieces, why not just make smaller
size sets??

Also, how does this relate to FILESPERSET?

We're all new to this.....

Thank you

On Wed, 27 Aug 2008 12:01:19 -0700 (PDT), artmerar-at-yahoo.com wrote:

>Sorry for the double post, but as we are reading and seeing BACKUPSET
>and BACKUPPIECE........we can see that a piece is part of a set. But,
>if you need to break up the set into pieces, why not just make smaller
>size sets??

A datafile can not span multiple backupsets.
A datafile can span multiple backuppieces.
You could configure 2G backuppieces (max filesize for 32-bit files on
some Unixes) and have a backupset of unlimited size.

>
>Also, how does this relate to FILESPERSET?
>
All files in a set will be
a) simultaneously opened
b) simultaneously backupped
c) get multiplexed in one backupset, so 1 block for datafile 1 is
followed by one block for datafile 2 etc.

If you have all your datafiles on few disks, NOT configuring
filesperset (Oracle by default tries to back up as much as possible)
create an I/O bottleneck.
You could argue filesperset always needs to be 1.


>We're all new to this.....
>
>Thank you

Hth
--
Sybrand Bakker
Senior Oracle DBA

On Wed, 27 Aug 2008 11:19:49 -0700 (PDT), artmerar-at-yahoo.com wrote:

>Hi,
>
>We're setting up RMAN and configuring our environment. We are on
>Oracle 10gR2. I'm having trouble understand these commands:
>
>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
>PARALLELISM 20;
>CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';
>
>
>They both specify disk. But, can they be combined into one command?

They can't.

If you issue
show all
you basically not only see the configuration, but also the commands
issued.

--
Sybrand Bakker
Senior Oracle DBA

On Aug 27, 2:24 pm, sybra...@hccnet.nl wrote:
> On Wed, 27 Aug 2008 12:01:19 -0700 (PDT), artme...@yahoo.com wrote:
> >Sorry for the double post, but as we are reading and seeing BACKUPSET
> >and BACKUPPIECE........we can see that a piece is part of a set. But,
> >if you need to break up the set into pieces, why not just make smaller
> >size sets??
>
> A datafile can not span multiple backupsets.
> A datafile can span multiple backuppieces.
> You could configure 2G backuppieces (max filesize for 32-bit files on
> some Unixes) and have a backupset of unlimited size.
>
>
>
> >Also, how does this relate to FILESPERSET?
>
> All files in a set will be
> a) simultaneously opened
> b) simultaneously backupped
> c) get multiplexed in one backupset, so 1 block for datafile 1 is
> followed by one block for datafile 2 etc.
>
> If you have all your datafiles on few disks, NOT configuring
> filesperset (Oracle by default tries to back up as much as possible)
> create an I/O bottleneck.
> You could argue filesperset always needs to be 1.
>
> >We're all new to this.....
>
> >Thank you
>
> Hth
> --
> Sybrand Bakker
> Senior Oracle DBA


Thank you Sybrand,

I'm sure this has a lot to do with performance. So, we'll take this
and try to play and see some stats.

On Aug 27, 2:40 pm, artme...@yahoo.com wrote:
> On Aug 27, 2:24 pm, sybra...@hccnet.nl wrote:
>
>
>
> > On Wed, 27 Aug 2008 12:01:19 -0700 (PDT), artme...@yahoo.com wrote:
> > >Sorry for the double post, but as we are reading and seeing BACKUPSET
> > >and BACKUPPIECE........we can see that a piece is part of a set. But,
> > >if you need to break up the set into pieces, why not just make smaller
> > >size sets??
>
> > A datafile can not span multiple backupsets.
> > A datafile can span multiple backuppieces.
> > You could configure 2G backuppieces (max filesize for 32-bit files on
> > some Unixes) and have a backupset of unlimited size.
>
> > >Also, how does this relate to FILESPERSET?
>
> > All files in a set will be
> > a) simultaneously opened
> > b) simultaneously backupped
> > c) get multiplexed in one backupset, so 1 block for datafile 1 is
> > followed by one block for datafile 2 etc.
>
> > If you have all your datafiles on few disks, NOT configuring
> > filesperset (Oracle by default tries to back up as much as possible)
> > create an I/O bottleneck.
> > You could argue filesperset always needs to be 1.
>
> > >We're all new to this.....
>
> > >Thank you
>
> > Hth
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Thank you Sybrand,
>
> I'm sure this has a lot to do with performance. So, we'll take this
> and try to play and see some stats.


Sybrand,

Forgive me for this last question.

I think I understand backupset & backuppiece. Usually each backupset
is allocated to a different channel.

Filesperset I'll have to do a bit more reading on as to understand why
3 files writing to 3 different backup sets vs 3 files writing to 1
backup set makes a difference.

MAXSETSIZE sets the maximum size per backupset, I assume. Would
setting both filesperset & maxsizeset conflict? I'm trying to think
about this. If you have 12 files, and you say you want 4 files per
set, thus 3 sets, and a maxsize of 50G per set.......you may get more
than 3 sets, defined by the previous filesperset value......

I'm probably wrong.....

On Wed, 27 Aug 2008 13:13:46 -0700 (PDT), artmerar-at-yahoo.com wrote:

>Sybrand,
>
>Forgive me for this last question.
>
>I think I understand backupset & backuppiece. Usually each backupset
>is allocated to a different channel.
>
>Filesperset I'll have to do a bit more reading on as to understand why
>3 files writing to 3 different backup sets vs 3 files writing to 1
>backup set makes a difference.
>
>MAXSETSIZE sets the maximum size per backupset, I assume. Would
>setting both filesperset & maxsizeset conflict? I'm trying to think
>about this. If you have 12 files, and you say you want 4 files per
>set, thus 3 sets, and a maxsize of 50G per set.......you may get more
>than 3 sets, defined by the previous filesperset value......
>
>I'm probably wrong.....
>

backupsets are NOT allocated to different channels unless you instruct
it do so. Channels are backup destinations, sending subsequent
backupsets to different channels doesn't make sense.

Three files written to 1 backupset are three files opened
*simultaneously* (by three different Oracle sessions),
read in parallel, and written in parallel to 1 backupset.

Rman will calculate the space required, with as guideline a datafile
can't span a backupset. If 4 files don't fit in 50 G, RMAN will create
extra sets and adjust the number of filesperset automatically.

--
Sybrand Bakker
Senior Oracle DBA

On 27 Ago, 20:19, artme...@yahoo.com wrote:
> Hi,
>
> We're setting up RMAN and configuring our environment. *We are on
> Oracle 10gR2. *I'm having trouble understand these commands:
>
> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> PARALLELISM 20;
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';
>
> They both specify disk. *But, can they be combined into one command?
> The documentation is really not specific on this. *They show different
> variants of the above, but I did not find anything on a combination of
> the commands. *If we can do it in one command, it makes more
> sense......
>
> Thank you.

If you see
http://download.oracle.com/docs/cd/B...5.htm#i1019177
you can configure different formats for different channels (for
different backup pieces and one backupset)
while "parallelism" and "compressed backupset" are "global" settings
for a backup set
you can configure different settings for different channells that
write different backup sets.
Hope this helps.

Regards,
Cristian Cudizio

http://cristiancudizio.wordpress.com

On Aug 28, 5:36 am, Cristian Cudizio
wrote:
> On 27 Ago, 20:19, artme...@yahoo.com wrote:
>
>
>
> > Hi,
>
> > We're setting up RMAN and configuring our environment. We are on
> > Oracle 10gR2. I'm having trouble understand these commands:
>
> > CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> > PARALLELISM 20;
> > CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';
>
> > They both specify disk. But, can they be combined into one command?
> > The documentation is really not specific on this. They show different
> > variants of the above, but I did not find anything on a combination of
> > the commands. If we can do it in one command, it makes more
> > sense......
>
> > Thank you.
>
> If you seehttp://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsyn...
> you can configure different formats for different channels (for
> different backup pieces and one backupset)
> while "parallelism" and "compressed backupset" are "global" settings
> for a backup set
> you can configure different settings for different channells that
> write different backup sets.
> Hope this helps.
>
> Regards,
> Cristian Cudizio
>
> http://cristiancudizio.wordpress.com

Thanks Cristian. I appreciate it. It helps me to understand all
that. I just need to see how different configurations will affect
performance. For example, do you use a certain level of parallelism
when you have certain number of disks, or size of database. Same with
maxsetsize and maxpiecesize, etc.......

Thanks!