Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

2135

积分

484

好友

184

主题

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

发表于 2013-4-6 14:32:50 | 查看: 3015| 回复: 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);
}
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

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

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

服务热线 : 13764045638  QQ: 47079569   
发表于 2013-4-7 00:20:59
如果是备份到磁盘,这样的参数设置有优化效果吗?

回复 显示全部楼层 道具 举报

发表于 2014-7-18 21:06:56
收藏,学习!

回复 显示全部楼层 道具 举报

发表于 2016-1-5 21:19:32
才见到,收藏了!

回复 显示全部楼层 道具 举报

您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2017-9-24 09:19 , Processed in 0.066235 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569