脚本实现热备份:
rem script:hotbak.sql
rem creater:fengzhu
rem date:12.12.2007
rem desc:backup all database datafile in archive
--connect database
connect sys/admin@orcl as sysdba;
--Del Data file
$del E:fzbak*.dbf;
--Del Control file
$del E:fzbak*.ctl;
--Del Log file
$del E:fzbak*.log;
--archive
alter system archive log current;
--start
alter database begin backup;
--Copy Data file
$xcopy D:oracleproduct10.2.0oradataorcl*.dbf E:fzbak;
--Copy Control file
$xcopy D:oracleproduct10.2.0oradataorcl*.ctl E:fzbak;
--Copy Log file
$xcopy D:oracleproduct10.2.0oradataorcl*.log E:fzbak;
alter database end backup;
--end
alter system archive log current;
将以上脚本保存为hotbak.sql然后打开sqlplus执行即可(注:文件路径根据实际情况更改)。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/755829/viewspace-977642/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/755829/viewspace-977642/