oracle rman備份及策略設定

 

?  RMAN備份：(資料檔案 引數檔案控制檔案 歸檔日誌檔案)

rman備份配置過程：

建立目錄：

mkdir –p /arch/backup/rman

chmod 770 /arch/backup/rman

建立物件：

create tablespace rman_data datafile ' /oradata/tts/rman_data.dbf'  size 1024 m autoextend on next 1m maxsize unlimited;

create temporary tablespace rman_tmp tempfile ' /oradata/tts/rman_tmp.dbf' size 100m autoextend on next 32m maxsize 2048m;

create user rman identified by rman default tablespace rman_data temporary tablespace rman_tmp;

grant connect,resource,recovery_catalog_owner to rman;

連線catalog,註冊資料庫：

rman catalog rman/rman

create catalog tablespace rman_data;

register database;

report schema;

--基於冗餘數量的設定

configure retention policy to redundancy 2;

--基於恢復視窗的設定

configure retention policy to recovery window of 7 days;

--設定自動備份控制檔案為開啟

CONFIGURE CONTROLFILE AUTOBACKUP ON;

全庫（0級）備份指令碼：

$ORACLE_HOME/bin/rman catalog rman/rman

connect  target sys/oracle

run {

allocate channel ch1 device type disk;

allocate channel ch2 device type disk;

allocate channel ch3 device type disk;

backup full database format '/arch/backup/rman/db_%U_%d.bak' tag="full" spfile include current controlfile;

sql 'alter system archive log current';

change archivelog all crosscheck;

backup archivelog all format '/arch/backup/rman/arch_%t_%s.bak'  tag="archivelog" delete all input;

crosscheck backup;

crosscheck archivelog all;

delete noprompt expired backup;

delete noprompt obsolete;

resync catalog;

release channel ch1;

release channel ch2;

release channel ch3;

}

備份RMAN資料庫：

export ORACLE_SID=tts

export NLS_LANG=american_america.ZHS16GBK

today=`date +20%y-%m-%d`

exp userid=rman/rman buffer=6553600 owner=rman file=/arch/backup/rman/rman$today.dmp log=/arch/backup/rman$today.log

?  邏輯匯出備份：

$ more exp.sh

export ORACLE_SID=tts

export NLS_LANG=american_america.ZHS16GBK

today=`date +20%y-%m-%d`

exp userid=system/oracle full=yes buffer=6553600 file=/arch/backup/full$today.dmp  log=/arch/backup/full$today.log 

?  定時任務：

在檔案/etc/crontab最後新增如下幾行：（最好使用絕對路徑）

1 23 * * * su - oracle -c rman.sh>>rman.log

1 22 * * * su - oracle -c exp.sh>>exp.log