共有两个文件back_cold.bat和back_cold.sql,通过定时任务来调用back_cold.bat

bat:

set day=%date:~0,10%
cd e:dbdata
md %day%
sqlplus /nolog @e:dbdataback_cold.sql %day%

sql:

Rem db cold backup;
conn sys/oracle as sysdba;
shutdown immediate;
host xcopy D:oracleoradatabjmobile*.ora e:dbdata&1;
host xcopy D:oracleoradatabjmobile*.log e:dbdata&1;
host xcopy D:oracleoradatabjmobile*.ctl e:dbdata&1;
startup;
exit;

ITPub博客

冷备份脚本

最新文章