返回数说广场
0
ALLOCATE CHANNEL CH00 type disk maxpiecesize 20G format '/oradata/rman_bak/%d_DB_%T_%u_%s_%p';
ALLOCATE CHANNEL CH01 type disk maxpiecesize 20G format '/oradata/rman_bak/%d_DB_%T_%u_%s_%p';
ALLOCATE CHANNEL CH02 type disk maxpiecesize 20G format '/oradata/rman_bak/%d_DB_%T_%u_%s_%p';
ALLOCATE CHANNEL CH03 type disk maxpiecesize 20G format '/oradata/rman_bak/%d_DB_%T_%u_%s_%p';
backup database;
release channel CH00;
release channel CH01;
release channel CH02;
release channel CH03;
sql 'alter system archive log current';
ALLOCATE CHANNEL CH00 type disk;
ALLOCATE CHANNEL CH01 type disk;
BACKUP filesperset 10 FORMAT '/oradata/rman_bak/al_%T_%s_%p_%t' ARCHIVELOG ALL not backed up 2 times;
DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'SYSDATE-7';
release channel CH00;
release channel CH01;
ALLOCATE CHANNEL CH00 type disk;
BACKUP FORMAT '/oradata/rman_bak/cntrl_%T_%s_%p_%t' CURRENT CONTROLFILE;
release channel CH00;
ALLOCATE CHANNEL CH00 type disk;
delete NOPROMPT backup completed before 'sysdate-15';
release channel CH00;
0
0 127
分享
评论
热门数说


