srvctl add service –d -s -r -a , srvctl add service –d -s -r -a , For example srvctl add service –d maclean –s bkup1 –r maclean1 –a maclean2,maclean3,maclean4,maclean5,maclean6,maclean7,maclean8 srvctl add service –d maclean –s bkup2 –r maclean2 –a maclean1,maclean3,maclean4,maclean5,maclean6,maclean7,maclean8 srvctl add service –d maclean –s bkup3 –r maclean3 –a maclean1,maclean2,maclean4,maclean5,maclean6,maclean7,maclean8 srvctl add service –d maclean –s bkup4 –r maclean4 –a maclean1,maclean2,maclean3,maclean5,maclean6,maclean7,maclean8 srvctl add service –d maclean –s bkup5 –r maclean5 –a maclean1,maclean2,maclean3,maclean4,maclean6,maclean7,maclean8 srvctl add service –d maclean –s bkup6 –r maclean6 –a maclean1,maclean2,maclean3,maclean4,maclean5,maclean7,maclean8 srvctl add service –d maclean –s bkup7 –r maclean7 –a maclean1,maclean2,maclean3,maclean4,maclean5,maclean6,maclean8 srvctl add service –d maclean –s bkup8 –r maclean8 –a maclean1,maclean2,maclean3,maclean4,maclean5,maclean6,maclean7 srvctl start service –d -s <service_name #1> Alternatively, to start all the services for a particular database srvctl start service –d run { allocate channel ch01 connect string ‘sys/@<scan_address>/<service_name>; allocate channel ch02 connect string ‘sys/@<scan_address>/<service_name>; allocate channel ch16 connect string ‘sys/@<scan_address>/<service_name>; backup database …; } For example run { allocate channel ch01 device type disk connect 'sys/welcome1@maclean-scan/bkup1'; allocate channel ch02 device type disk connect 'sys/welcome1@maclean-scan/bkup2'; allocate channel ch03 device type disk connect 'sys/welcome1@maclean-scan/bkup3'; allocate channel ch04 device type disk connect 'sys/welcome1@maclean-scan/bkup4'; allocate channel ch05 device type disk connect 'sys/welcome1@maclean-scan/bkup5'; allocate channel ch06 device type disk connect 'sys/welcome1@maclean-scan/bkup6'; allocate channel ch07 device type disk connect 'sys/welcome1@maclean-scan/bkup7'; allocate channel ch08 device type disk connect 'sys/welcome1@maclean-scan/bkup8'; allocate channel ch09 device type disk connect 'sys/welcome1@maclean-scan/bkup1'; allocate channel ch10 device type disk connect 'sys/welcome1@maclean-scan/bkup2'; allocate channel ch09 device type disk connect 'sys/welcome1@maclean-scan/bkup1'; allocate channel ch10 device type disk connect 'sys/welcome1@maclean-scan/bkup2'; allocate channel ch11 device type disk connect 'sys/welcome1@maclean-scan/bkup3'; allocate channel ch12 device type disk connect 'sys/welcome1@maclean-scan/bkup4'; allocate channel ch13 device type disk connect 'sys/welcome1@maclean-scan/bkup5'; allocate channel ch14 device type disk connect 'sys/welcome1@maclean-scan/bkup6'; allocate channel ch15 device type disk connect 'sys/welcome1@maclean-scan/bkup7'; allocate channel ch16 device type disk connect 'sys/welcome1@maclean-scan/bkup8'; backup as backupset incremental level 0 section size 128g database; }
备份TB级别Oracle数据库的一些技巧
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
备份TB级别数据的一些技巧
1、 考虑使用增量备份, 不要老是想着用全量备份
2、 对于增量备份而言 开启block change tracking 能极大地减少物理读,提升速度
3、 11g以后对于bigfile tablespace可以启用section size 来提升速度
4、 考虑到负载更低的 Data Guard物理备库上去做备份
5、 启用备份并行
CONFIGURE DEVICE TYPE DISK PARALLELISM 16;
6、 对于多节点RAC 使用 service控制负载均衡
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Windows调试Oracle数据库问题的一些手段
最近需要在Windows的跳板机上访问远程的Oracle数据库进行调试。Windows中只有
数据库 java python linux mysql -
Oracle 一些命令查看数据库和表
Oracle 一些命令查看数据库和表
Oracle 命令查看数据库