Oracle DBA日常维护工作手册参考6

RMAN备份环境初始化设置：

rman nocatalog

rman>connect target sys/oracle

rman>configure controlfile autobackup on;

rman>configure controlfile autobackup format for device type disk to ‘f:\rman_bak\%F.ctl’;

rman>configure snapshot controlfile name to ‘f:\rman_bak\snap_%F.ctl’;

Rman备份命令写到一个脚本中，在命令行中执行这个脚本

RMAN TARGET / NOCATALOG sys/oracle CMDFILE f:\ backup_incre_1.rcv
LOG f:\ backup_incre_1.log

增量备份脚本： backup_incre_1.rcv

run

{allocate channel c1 type DISK ;

backup incremental level = 1 format ‘f:\rman_bak\incre_1_%d_%s_%p.bak’

(database include current controlfile);

backup format ‘f:\rman_bak\arch%u_%s_%p.bak’

(archivelog from time ‘sysdate-1’ all delete input);

}

显示RMAN备份集信息：

RMAN> list backupset;