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;
}
2013年1月1日
备份TB级别Oracle数据库的一些技巧
M
mac
Author
7 min
Read Time
37
Views
备份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控制负载均衡