Tuning the time taken for RMAN Backup
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