创建周一周四的0级完全备份
创建二三五六日的1级增量备份
使用job 完成RMAN 备份工作
使用scheduler 来控制RMAN JOB的执行时间
创建rman 的零级备份脚本

vi $ORACLE_BASH/admin/rman/inc0_backup.rmn

run

{ crosscheck backup;

crosscheck archivelog all;

delete noprompt expired backup device type disk;

delete noprompt obsolete device type disk;

backup incremental level 0 cumulative device type disk tag '%TAG' database;

backup device type disk tag '%TAG' archivelog all not backup delete all input;

}

创建rman 的1级增量备份脚本

vi $ORACLE_BASH/admin/rman/inc1_backup.rmn

run{

crosscheck backup;

crosscheck archivelog all;

delete noprompt expired backup device type disk;

delete noprompt obsolete device type disk;

backup incremental level 1 cumulative device type disk tag '%TAG' database;

backup device type disk tag '%TAG' archivelog all not backup delete all input;

}

创建0级完全备份shell 脚本

vi $ORACLE_BASH/admin/rman/inc0_backup.sh

#!/bin/sh

export ORACLE_SID=ENMOEDU

export ORACLE_BASH=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASH/product/11.2.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

$ORACLE_HOME/bin/rman target /

@$ORACLE_BASH/admin/$ORACLE_SID/rman/inc0_backup.rmn

log=$ORACLE_BASE/admin/$ORACLE_SID/rman/inc0_backup.log

exit

创建1级增量备份shell脚本

vi $ORACLE_BASH/admin/rman/inc1_backup.sh

#!/bin/sh
export ORACLE_SID=ENMOEDU
export ORACLE_BASH=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASH/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
$ORACLE_HOME/bin/rman target /
@$ORACLE_BASH/admin/$ORACLE_SID/rman/inc1_backup.rmn
log=$ORACLE_BASE/admin/$ORACLE_SID/rman/inc1_backup.log
exit

~

~

创建信任对象

begin
dbms_scheduler.create_credential(
credential_name =>'EXTERNAL_BACKUP_JOBS',
username=>'oracle',
password =>'oracle');
end;
/

创建1级备份的job

begin

sys.dbms_scheduler.create_job(

job_name=>'INC1_BACKUP',

job_type=>'EXECUTABLE',

job_action=>'/u01/app/oracle/admin/rman/inc1_backup.sh',

repeat_interval=> 'FREQ=WEEKLY;BYDAY=TUE,WED,FRI,SAT,SUN;BYHOUR=2;BYMINUTE=0',

start_date=>systimestamp at time zone 'ASIA/shanghai',

enabled=>true,

credential_name=> 'EXTERNAL_BACKUP_JOBS');

END;

/

执行0级完全备份的job

exec dbms_scheduler.run_job('INC0_BACKUP');

查看job 完成情况

select log_date,status,error#,actual_start_date,run_duration

from dba_scheduler_job_run_details

where owner= 'SYS'

and job_name like'INC%_BACKUP'

order by actual_start_date;

ITPub博客

设定RMAN 定时备份策略

最新文章