oracle备份命令 rman,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];   #不加序号则删除全部备份