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;