Maclean Liu(刘相兵 发表于 2013-4-6 14:32:50

rman优化备份性能脚本

CONFIGURE DEFAULT DEVICE TYPE TO SBT;
CONFIGURE DEVICE TYPE SBT PARALLELISM 40;
CONFIGURE CHANNEL DEVICE TYPE SBT MAXOPENFILES=1 PARMS='BLKSIZE=1048576, ENV=(NB_ORA_CLASS=Oracle_backup)' FORMAT '%U_%t';

sbt 备份

sql 'alter session set _db_file_direct_io_count=8388608';

sql 'alter session set "_backup_ksfq_bufsz"=4194304  ';
sql 'alter session set "_backup_ksfq_bufcnt"=64 ';



run
{

allocate channel mac1 TYPE SBT MAXOPENFILES=1 PARMS='BLKSIZE=1048576, ENV=(NB_ORA_CLASS=Oracle_backup)' FORMAT '%U_%t';
backup as compressed backupset database;
}



run
{
allocate channel mac1 TYPE disk MAXOPENFILES=1 FORMAT '%U_%t';
backup as compressed backupset database;

}









sql 'alter session set "_backup_ksfq_bufsz"=4194304 ';
sql 'alter session set "_backup_ksfq_bufcnt"=64 ';


run
{ allocate channel mac01  DEVICE TYPE DISK MAXOPENFILES=1 PARMS='BLKSIZE=1048576' ;
   allocate channel mac02  DEVICE TYPE DISK MAXOPENFILES=1 PARMS='BLKSIZE=1048576' ;
   allocate channel mac03  DEVICE TYPE DISK MAXOPENFILES=1 PARMS='BLKSIZE=1048576' ;
   allocate channel mac04  DEVICE TYPE DISK MAXOPENFILES=1 PARMS='BLKSIZE=1048576' ;
   backup as copy (datafile 1,2   format '/s01/backup/%U.bak' channel mac01)
   (datafile 3,4    format '/s01/backup/%U.bak'   channel mac02)
   (datafile 5,6  format '/s01/backup/%U.bak'  channel mac03);
}




  run
{ allocate channel mac01  DEVICE TYPE DISK  ;
   allocate channel mac02  DEVICE TYPE DISK  ;
   allocate channel mac03  DEVICE TYPE DISK  ;
   allocate channel mac04  DEVICE TYPE DISK  ;
   backup as copy (datafile 1,2   format '/s01/backup/%U.bak' channel mac01)
   (datafile 3,4    format '/s01/backup/%U.bak'   channel mac02)
   (datafile 5,6  format '/s01/backup/%U.bak'  channel mac03);
}

xifenfei 发表于 2013-4-7 00:20:59

如果是备份到磁盘，这样的参数设置有优化效果吗？

justinleisure 发表于 2014-7-18 21:06:56

收藏，学习！

reneejor 发表于 2016-1-5 21:19:32

才见到，收藏了!
页: [1]
查看完整版本: rman优化备份性能脚本