2135 积分	502 好友	184 主题

发消息

[物理/逻辑坏块] rman优化备份性能脚本

1^#

发表于 2013-4-6 14:32:50 | 查看: 7462| 回复: 3

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);
}

优化

分享0

相关帖子

下载专业ORACLE数据库恢复工具PRM-DUL For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ: 47079569

收藏0 回复只看该作者道具举报