Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tuning the time taken for RMAN Backup

sunil kumarMar 30 2012 — edited Apr 2 2012
Hi all,


In our database, the RMAN backup runs for more then 10 hrs. We take full backup everyday. (Cant use incremental policy due to management decision even though we take level 0 backup everyday)

The database version is 11.1.0.7.0 on AIX-6.
The size of the database is around 2TB and its using
4 tape drives for backup. Due to limitation on resources we are unable to allocate more tape drives.
Total Number of Datafiles is around 240.
backup_tape_io_slaves is set to TRUE.

Can you please advise upon what should be the optimal value of FILEPERSET and MAXOPENFILES for this scenario.. i currently have FILEPERSET 4,
or any other solution to improve on the time for backup.
Below is the rman script we use.

run {
allocate channel c1 type 'SBT_TAPE';
allocate channel c2 type 'SBT_TAPE';
allocate channel c3 type 'SBT_TAPE';
allocate channel c4 type 'SBT_TAPE';
backup
incremental level 0
skip inaccessible
tag b_db_full
filesperset 4
format 'df_t%t_s%s_p%p'
(database include current controlfile);
sql 'alter system archive log current';
backup
format 'al_t%t_s%s_p%p'
filesperset 2
(archivelog all delete input);
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2012
Added on Mar 30 2012
3 comments
668 views