1、手动冷备份
将数据库正常shutdown后再将%oracle_home%oradata(SID)下全部的contorlfile、datafile、redolog拷贝到备份目录。[@more@]
2、脚本实现冷备份
编写冷备份脚本如下:
rem script:coldbak.sql
rem creater:fengzhu
rem date:12.10.2007
rem desc:offline full backup database
--connect database
connect as sysdba;
--shutdown database
shutdown immediate;
--Copy Data file
--在linux下xcopy前的$符号改改为!
$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;
--startup database
startup open orcl;
将以上脚本保存为coldbak.sql然后打开sqlplus直接执行即可。