Ctrl+R
CMD
rem 创建一个每周 一二三四五六七 23:00都执行的计划,命令如下;
------------------------------------------------------------------------
at 23:00 /every:m,t,w,th,f,s,su Y:\rman.bat
------------------------------------------------------------------------
rem 在Y盘创建一个rman.bat文件,等待计划调用,
rem 计划执行rman.txt脚本,同时在Y盘下生成rman.log日志
rem 内容如下;
------------------------------------------------------------------------
@echo off
cd /d ORACLE_HOME\BIN\
rman cmdfile=Y:\rman.txt msglog=Y:\rman.log
------------------------------------------------------------------------
rem Y盘创建一个rman.txt脚本文件,等待rman.bat调用,
rem 脚本内容
rem 备份数据文件,
rem 备份控制文件,
rem 备份归档日志文件,
rem 删除备份的归档日志
rem 保留1个有效备份集
rem 内容如下;
查看或者修改备份集;
RMAN> show retention policy;
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
------------------------------------------------------------------------
connect target /
report obsolete;
delete obsolete;
run {
allocate channel c0 type disk
maxpiecesize = 1024m format 'Y:\oracle\bak\oracle_%U.dblzk';
backup incremental level 0 skip inaccessible tag Backup_Level0 database;
release channel c0;
allocate channel c0 type disk
maxpiecesize = 1024m format 'Y:\oracle\bak\oracle_%U.ctllzk';
backup skip inaccessible tag Backup_Controlfile current controlfile;
release channel c0;
allocate channel c0 type disk
maxpiecesize = 1024m format 'Y:\oracle\bak\oracle_%U.loglzk';
backup archivelog all delete input;
release channel c0;
}
------------------------------------------------------------------------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7755871/viewspace-740576/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7755871/viewspace-740576/