创建周一周四的0级完全备份
创建二 三 五六日的1级增量备份
使用job 完成RMAN 备份工作
使用scheduler 来控制RMAN JOB的执行时间
创建rman 的零级备份脚本
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 完成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;
}
{ 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;
}
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脚本
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
~
~
创建信任对象
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;
/
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;
from dba_scheduler_job_run_details
where owner= 'SYS'
and job_name like'INC%_BACKUP'
order by actual_start_date;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30166976/viewspace-1668765/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30166976/viewspace-1668765/