最近在鼓捣ORACLE,之前不太熟悉。为了备份和还原,折腾了很久,终于搞定了备份,综合了网上收集的资料和自己的经验,整理如下:
第一步,首先,建立一个批处理文件如下:
echo off
echo PUMA Database Backup Batch File
echo BY Michael Chen
color 0b & cls
echo Starting backup XXXXX Database!!!...
echo DO NOT INTERRUPT DURING BACKUP......
set "tbuf=C:\Backup"
echo Configue Backup File Name(Named by weekday, ONLY BACKUP LAST ONE WEEK COPIES)
set name=%date%
set name=%name:~-3%
set name=PUMA_backup_%name%
echo CHECK AND DELETE EXISTED SANMED NAME FILE...
if exist %tbuf%\%name%.dmp del %tbuf%\%name%.dmp
if exist %tbuf%\%name%.log del %tbuf%\%name%.log
echo STARTING FULLY BACKUP WHOLE DATABASE...
set oracle_sid = testDB
exp 账户/密码 full=y file=%tbuf%\%name%.dmp log=%tbuf%\%name%.log
echo DATABASE SUCCESSFULLY BACKUP!
注意:备份文件存放文件夹必须事先创建好,根据实际情况修改文件夹及数据库密码。
第二步,添加任务计划,打开控制面板-任务计划-添加任务计划,设置每天执行备份数据库.bat,最好在晚上执行如凌晨2点。