rman
connect target /
也可以
rman target sys/oracle@test db 连接远程数据库
记录rman执行的日志:
rman target / log /home/oracle/rmanLog.txt
show all//显示所有rman参数
CONFIGURE RETENTION POLICY 配置备份保留策略
基于时间:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF n DAYS;
基于冗余数量:
CONFIGURE RETENTION POLICY TO REDUNDANCY n ;
CONFIGURE BACKUP OPTIMIZATION 配置备份优化
打开备份优化:
CONFIGURE BACKUP OPTIMIZATION ON;
关闭备份优化:
CONFIGURE BACKUP OPTIMIZATION OFF ;
CONFIGURE DEFAULT DEVICE TYPE 配置IO设备类型
使用磁盘设备:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
使用磁带设置:
CONFIGURE DEFAULT DEVICE TYPE TO SBT;
CONFIGURE CONTROLFILE AUTOBACKUP 配置控制文件自动备份
打开自动备份
CONFIGURE CONTROLFILE AUTOBACKUP ON
禁止自动备份
CONFIGURE CONTROLFILE AUTOBACKUP OFF
CONFIGURE DEVICE TYPE 设置并行备份
RMAN 支持并行备份与恢复,也可以在配置中指定默认的并行程度。例如:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES 设置备份文件冗余度
CONFIGURE MAXSETSIZE 配置备份集的最大尺寸
备份数据库:
run{
allocate channel c1 type disk;
backup full tag 'yushhdbfull' format '/home/oracle/rman/full%u_%s_%p'database
include current controlfile;
sql 'alter system archive log current';
release channel c1;
}
查看刚才的备份:
list backup of database;
备份表空间:
backup tablespace travel;
备份指定数据文件:
BACKUP DATAFILE n
备份控制文件:
通过CONFIGURE命令将CONTROLFILE AUTOBACKUP置为ON,
BACKUP CURRENT CONTROLFILE;
LIST BACKUP OF CONTROLFILE;
备份归档日志文件:
BACKUP ARCHIVELOG ALL;