oracle 压缩备份,Oracle rman 压缩备份配置及脚本

run{

backup as compressed backupset database format '/data/yanjing_bak/full_compressd_%U.dbf'

plus archivelog format '/data/yanjing_bak/arc_compressed_%U.arc';

}

你可以选择在备份命令里显示指定压缩选项:

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

--仅对1,5文件压缩备份

BACKUP AS COMPRESSED BACKUPSET DATAFILE 1,5;

也可以配置RMAN指定压缩选项:

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

但是压缩备份会消耗更多的资源以及时间。

configure device type disk backup type to compressed backupset;

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO backupset;

阅读(946) | 评论(0) | 转发(0) |