RMAN备份命令

查看
show all;          
list backup;
report absolete;      #基于现有保留策略,不再需要的备份
report need backup;
report schema       #显示表空间信息

配置
configure device type disk parallelism 3;  #3个通道
configure device type disk backup type to compressed backupset;    #默认压缩备份集
#configure channel device type disk maxpiecesize=200M; #backup piece 200M
#configure retention policy to recovery window of 3 days; #恢复窗口
#configure retention policy to redundancy 2;  #冗余度2
#configure default device type to disk|sbt;    #默认备份设备
#configure channel device type disk format='/backup/%U'; #默认备份路径和文件名
#configure controlfile autobackup on;    #控制文件自动备份
#configure backup optimization on;                       #服务进程发起多次备份时,同一日志不会重复备份
#configure archivelog deletion policy to [applied,none]; #是否应用保留策略删除文件

全备份
>backup database;                           //全备份,不备份空白块,备份集存储在数据库闪回存储区
>backup tablespace system;   //备份system表空间
>backup fileperset=2 tablespace users,system; //备份多个表空间
>backup current controlfile;  //备份控制文件
>backup archivelog all;              //备份全部归档日志[delete all input]备份结束后删除全部
>backup archivelog like '/arch/dest%';  //[delete input]备份结束后删除
      plus archivelog                #备份其它文件时备份归档日志
     including current controlfile  #备份其它文件时备份控制文件
>backup database not backed up;   #只备份未备份过的数据文件

增量备份
>backup incremental level 0 database;
>backup incremental level 1 database;   #一级差异
>backup incremental level 1 cumulative database; #一级累积
>backup incremental level 0 tablespace system;
>backup incremental level 0 datafile 3;
>backup incremental level 0 database plus archivelog;

镜像备份
>backup as copy database;

校验
crosscheck
validate

删除
delete obsolete     #删除过时备份,有确认提示
delete noprompt obsolete; #同上,无确认提示
delete backup [2];   #不加序号则删除全部备份

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30077753/viewspace-1409886/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30077753/viewspace-1409886/