Oracle物理备份方案
一.概述
数据库的物理备份以一个星期为单元,星期一到星期六作数据库的1级备份,星期天做0级备份。物理备份不考虑逻辑更加安全有效,以保证念数据库能稳定地运行。
二.数据库备份具体方案
1.0级备份方案
1) 建立文件夹”d:\backup”; 建立文件夹”d:\backup\scripts”;建立文件bak_inc0.rcv放入文件夹”d:\backup\scripts”,其内容为:
run{
allocate channel c1 type disk;
backup
incremental level 0
tag='INC_0'
database include current controlfile
format 'd:\backup\Inc0_%d_%T_%s'
plus archivelog filesperset 20
format 'd:\backup\Inc0_%d_%T_%s' delete all input;
crosscheck backup;
delete noprompt expired backup;
report obsolete;
delete noprompt obsolete;
release channel c1;
}
2) 建立文件夹”d:\backup\logs”;建立批处理文件”v3x_inc0_backup.bat”放入”d盘”,其内容如下:
set oracle_sid=orcl
set NLS_LANG=American_america.AL32UTF8
rman target jwst/jwst nocatalog cmdfile=D:\backup\scripts\bak_inc0.rcv msglog d:\backup\logs\v3x_%date:~0,4%_%date:~5,2%_%date:~8,2%.log
3)将批处理文件放入windows任务计划中,每个星期天晚上2点执行。