------=_Part_12362_5687690.1143024868279
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
RUN {
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';
BACKUP
$BACKUP_TYPE
FILESPERSET 20
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
# backup all archive logs
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
#
# Note: During the process of backing up the database, RMAN also backs up
the
# control file. This version of the control file does not contain the
# information about the current backup because "nocatalog" has been
specified.
# To include the information about the current backup, the control file
should
# be backed up as the last step of the RMAN section. This step would not b=
e
# necessary if we were using a recovery catalog.
#
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';
BACKUP
# recommended format
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EOF
On 3/22/06, andrew.x.smith AT jpmchase DOT com <andrew.x.smith AT jpmchase DOT
com> wrote=
:
>
>
> This is moving into the realms of RMAN performance tuning so you may get
> better advise from an Oracle board on this.
> Your default settings look ok to me, you could try testing with different
> values for CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4; to see which
> gives the best performance. Also all of the settings you provided can be
> overwritten by the RMAN script, can you post this too?
>
>
>
>
>
> *"Atif Munir" <atif76 AT gmail DOT com>*
> Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu
>
> 22/03/2006 06:44
>
> To: veritas-bu AT mailman.eng.auburn DOT edu
> cc:
> Subject: [Veritas-bu] rman backups are slow
>
>
> I am unable to get more than 50MB/sec for rman backups. Although
> filesystem backups are running 100MB/sec.
>
> Is there any conf changes required in the rman. I have rman setting like
> this.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
> RMAN> show all;
>
> RMAN configuration parameters are:
> CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
> CONFIGURE BACKUP OPTIMIZATION ON;
> CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> default
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO
> '%F'; # default
> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4;
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
> default
> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS "BLKSIZE=3D1048576";
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
> '/oracle/product/9.2.0.4/dbs/snapcf_ebizprod.f'; # default
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>
>
------=_Part_12362_5687690.1143024868279
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
RUN {<br>
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';<br>
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';<br>
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';<br>
BACKUP<br>
$BACKUP_TYPE<br>
FILESPERSET 20<br>
# recommended format<br>
FORMAT 'bk_%s_%p_%t'<br>
DATABASE;<br>
sql 'alter system archive log current';<br>
RELEASE CHANNEL ch01;<br>
RELEASE CHANNEL ch02;<br>
# backup all archive logs<br>
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';<br>
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';<br>
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';<br>
BACKUP<br>
filesperset 20<br>
FORMAT 'al_%s_%p_%t'<br>
ARCHIVELOG ALL DELETE INPUT;<br>
RELEASE CHANNEL ch01;<br>
RELEASE CHANNEL ch02;<br>
#<br>
# Note: During the process of backing up the database, RMAN also backs up t=
he<br>
# control file. This version of the control file does not contain the=
<br>
# information about the current backup because "nocatalog" has be=
en specified.<br>
# To include the information about the current backup, the control file sho=
uld<br>
# be backed up as the last step of the RMAN section. This step would =
not be<br>
# necessary if we were using a recovery catalog.<br>
#<br>
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';<br>
SEND 'NB_ORA_SERV=3Dserver-backup,NB_ORA_CLIENT=3Dserver';<br>
BACKUP<br>
# recommended format<br>
FORMAT 'cntrl_%s_%p_%t'<br>
CURRENT CONTROLFILE;<br>
RELEASE CHANNEL ch00;<br>
}<br>
EOF<br>
<br><br><div><span class=3D"gmail_quote">On 3/22/06, <b class=3D"gmail_send=
ername"><a href=3D"mailto:andrew.x.smith AT jpmchase DOT
com">andrew.x.smith@jpmch=
ase.com</a></b> <<a href=3D"mailto:andrew.x.smith AT jpmchase DOT
com">andrew.x=
.smith AT jpmchase DOT com
</a>> wrote:</span><blockquote class=3D"gmail_quote" style=3D"border-lef=
t: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1=
ex;"><div style=3D"direction: ltr;">
<br><font face=3D"sans-serif" size=3D"2">This is moving into the realms of =
RMAN performance tuning so you may get better advise from an Oracle board o=
n this.</font>
<br><font face=3D"sans-serif" size=3D"2">Your default settings look ok to m=
e, you could try testing with different values for </font><font face=3D"Cou=
rier New" size=3D"2">CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4;</font>=
<font face=3D"sans-serif" size=3D"2">
to see which gives the best performance. Also all of the settings you
provided can be overwritten by the RMAN script, can you post this too?</fon=
t>
<br>
<br><font face=3D"sans-serif" size=3D"2"> </font>
<br>
<br>
<br>
<table width=3D"100%">
<tbody><tr valign=3D"top">
<td>
<br>
</td><td><font face=3D"sans-serif" size=3D"1"><b>"Atif Munir" <=
;<a href=3D"mailto:atif76 AT gmail DOT com" target=3D"_blank" onclick=3D"return
to=
p.js.OpenExtLink(window,event,this)">atif76 AT gmail DOT com</a>></b></font>
<br><font face=3D"sans-serif" size=3D"1">Sent by: <a href=3D"mailto:veritas=
-bu-admin AT mailman.eng.auburn DOT edu" target=3D"_blank" onclick=3D"return
top.j=
s.OpenExtLink(window,event,this)">veritas-bu-admin AT mailman.eng.auburn DOT
edu</=
a></font>
<p><font face=3D"sans-serif" size=3D"1">22/03/2006 06:44</font>
<br>
</p></td><td><font face=3D"Arial" size=3D"1"> </=
font>
<br><font face=3D"sans-serif" size=3D"1"> To: &n=
bsp; <a href=3D"mailto:veritas-bu AT mailman.eng.auburn DOT
ed=
u" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this=
)">veritas-bu AT mailman.eng.auburn DOT edu</a></font>
<br><font face=3D"sans-serif" size=3D"1"> cc: &n=
bsp; </font>
<br><font face=3D"sans-serif" size=3D"1"> Subjec=
t: [Veritas-bu] rman backups are slow</font></td=
></tr></tbody></table>
<br>
<br>
<br><font face=3D"Courier New" size=3D"2"></font></div><font face=3D"Courie=
r New" size=3D"2"></font><div style=3D"direction: ltr;"><span class=3D"e" i=
d=3D"q_10a217dd7434d397_1"><font face=3D"Courier New" size=3D"2">I am unabl=
e to get more than 50MB/sec for rman backups. Although
<br>
filesystem backups are running 100MB/sec.<br>
<br>
Is there any conf changes required in the rman. I have rman setting like th=
is.<br>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D<br>
RMAN> show all;<br>
<br>
RMAN configuration parameters are:<br>
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<br>
CONFIGURE BACKUP OPTIMIZATION ON;<br>
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br>
CONFIGURE CONTROLFILE AUTOBACKUP ON;<br>
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # def=
ault<br>
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO<br>
'%F'; # default<br>
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;<br>
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4;<br>
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br>
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default<b=
r>
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br>
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default=
<br>
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS "BLKSIZE=3D104857=
6";<br>
CONFIGURE MAXSETSIZE TO UNLIMITED; # default<br>
CONFIGURE SNAPSHOT CONTROLFILE NAME TO<br>
'/oracle/product/9.2.0.4/dbs/snapcf_ebizprod.f'; # default<br>
<br>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D<br>
<br></font></span></div><font face=3D"Courier New" size=3D"2"></font><div s=
tyle=3D"direction: ltr;">
<font face=3D"Courier New" size=3D"2">_____________________________________=
__________<br>
Veritas-bu maillist - <a href=3D"mailto:Veritas-bu AT mailman DOT
eng.=
auburn.edu" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,e=
vent,this)">Veritas-bu AT mailman.eng.auburn DOT edu</a><br>
<a href=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; targe=
t=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">http:=
//mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</a><br>
</font>
<br>
<br>
</div></blockquote></div><br>
------=_Part_12362_5687690.1143024868279--
|
