As for FS backups i can achieve 100MB/sec.
For test backup i have turn the optimization on but for production i will keep it off and we are using crosscheck option to sync the catalog.
Regards,
atif
On 3/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:
Ok so your script is limiting your parallisms to 2, you could try adding more streams by adding in additional allocated channel commands. To run four streams you would do:
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch04 TYPE 'SBT_TAPE';
Also FYI CONFIGURE BACKUP OPTIMIZATION ON; can cause data loss on your backups if you don't fully understand the implications of this.
Use caution when enabling backup optimization if you use a media manager with its own internal expiration policy. Run CROSSCHECK periodically to synchronize the RMAN repository with the media manager. Otherwise, RMAN may skip backups due to optimization without recognizing that the media manager has discarded backups stored on tape.
But I really would recommend getting a good DBA to help you out with all of this....
Sent by: [EMAIL PROTECTED]22/03/2006 10:54
To: "[EMAIL PROTECTED]" < [EMAIL PROTECTED]>
cc: veritas-bu@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] rman backups are slow
RUN {
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=server-backup,NB_ORA_CLIENT=server';
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=server-backup,NB_ORA_CLIENT=server';
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 be
# necessary if we were using a recovery catalog.
#
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=server-backup,NB_ORA_CLIENT=server';
BACKUP
# recommended format
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EOF
On 3/22/06, [EMAIL PROTECTED] < [EMAIL PROTECTED] > 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" < [EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]22/03/2006 06:44
To: veritas-bu@mailman.eng.auburn.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.
=========================================================
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=1048576";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/oracle/product/9.2.0.4/dbs/snapcf_ebizprod.f'; # default
===================================================
_______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
