oracle 10g允许对备份集进行压缩,直接备份到磁带不能直接压缩。
RUN {
ALLOCATE CHANNEL ch0 TYPE disk maxpiecesize 10G ;
BACKUP as compressed backupset DATABASE FORMAT='E:\BACKUP\%U' ;
BACKUP CURRENT CONTROLFILE;
SQL 'alter system switch logfile';
# backup archivelog time between 'sysdate-3' and 'sysdate';
RELEASE CHANNEL ch0;
}
阅读(705) | 评论(0) | 转发(0) |