[Veritas-bu] rman backups are slow
2006-10-04 00:15:05
Subject: |
[Veritas-bu] rman backups are slow |
From: |
atif76 at gmail.com (Atif Munir) |
Date: |
Wed, 4 Oct 2006 09:15:05 +0500 |
I am using netbackup 5.1 with rman for my oracle database backups.OS is
Solaris 9 with oracle 9.2.0.7 and I am unable to get a speed more than
50MB/sec. For FS backup this speed is 100MB/sec but for rman I get
stucked at 50MB/sec. I don't know why I am unable to get more speed.
The library is L100 and I am using two drives for backup. By increasing
number of drives or number of channels the backup speed is not going to
be better.
The tunning I have made so far is.
NET_BUFFER_SZ as 262144
NUMBER_DATA_BUFFERS=64
SIZE_DATA_BUFFERS=1048576
The rman backup script is like this.
CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR catalog rman/rman at rman trace
/u09/rman.trc msglog $RMAN_LOG_FILE append << EOF
RUN {
debug io;
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576'
MAXOPENFILES=20;
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576'
MAXOPENFILES=20;
SEND 'NB_ORA_SERV=bserver-bk,NB_ORA_CLIENT=client3-bk';
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' PARMS 'BLKSIZE=1048576';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576';
SEND 'NB_ORA_SERV=bserver-bk,NB_ORA_CLIENT=client3-bk';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
Any idea will be highly appreciated.
thanks,
atif
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] rman backups are slow,
Atif Munir <=
|
|
|