configure backup optimization_optimization problem_delivery(2)

configure device type disk|stb parallelism 2;

configure device type disk|stb clear;

configure channel device type disk format ''e/:rmanback_%U'';

configure channel device type disk maxpiecesize 100m

configure channel device type disk rate 1200K

configure channel 1 device type disk format ''e/:rmanback_%U'';

configure channel 2 device type disk format ''e/:rmanback_%U'';

configure channel 1 device type disk maxpiecesize 100m

2.06 生成备份副本 datafile|archivelog backup copies

configure datafile backup copies for device type disk|stb to 3;

configure archivelog backup copies for device type disk|stb to 3;

configure datafile|archivelog backup copies for device type disk|stb clear

BACKUP DEVICE TYPE DISK DATABASE

FORMAT ''/disk1/backup/%U'', ''/disk2/backup/%U'', ''/disk3/backup/%U'';

2.07 排除选项 exclude

configure exclude for tablespace ''users'';

configrue exclude clear;

2.08 备份集大小 maxsetsize

configure maxsetsize to 1G|1000M|1000000K|unlimited;

configure maxsetsize clear;

2.09 其它选项 auxiliary

CONFIGURE AUXNAME FOR DATAFILE 1 TO ''/oracle/auxfiles/aux_1.f'';

CONFIGURE AUXNAME FOR DATAFILE 2 TO ''/oracle/auxfiles/aux_2.f'';

CONFIGURE AUXNAME FOR DATAFILE 3 TO ''/oracle/auxfiles/aux_3.f'';

CONFIGURE AUXNAME FOR DATAFILE 4 TO ''/oracle/auxfiles/aux_4.f'';

-

CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;

CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;

CONFIGURE AUXNAME FOR DATAFILE 3 CLEAR;

CONFIGURE AUXNAME FOR DATAFILE 4 CLEAR;

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-39828-2.html