c:dbbak.bat

dbbak.bat内容如下：

sqlplus / as sysdba @ dbbak.sql

把批处理文件dbbak.bat放到任务计划里或者通过at命令调用就可以实现自动备份db

--================================

select 'alter tablespace '||tablespace_name||' begin backup;' from dba_data_files;

select 'host copy '||file_name||' C:oracleproduct10.2.0oradataonline;' from dba_data_files

select 'alter tablespace '||tablespace_name||' end backup;' from dba_data_files;

dbbak.sql脚本内容可以通过上面语句构造

dbbak.sql内容如下：

alter tablespace USERS begin backup;
alter tablespace UNDOTBS2 begin backup;
alter tablespace SYSAUX begin backup;
alter tablespace UNDOTBS1 begin backup;
alter tablespace SYSTEM begin backup;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTUSERS01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTUNDOTBS02.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTSYSAUX01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTUNDOTBS01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTSYSTEM01.DBF C:oracleproduct10.2.0oradataonline;
alter tablespace USERS end backup;
alter tablespace UNDOTBS2 end backup;
alter tablespace SYSAUX end backup;
alter tablespace UNDOTBS1 end backup;
alter tablespace SYSTEM end backup;

--===============================

一个更简单的脚本是：

alter database begin backup;

host copy C:ORACLEPRODUCT10.2.0ORADATATESTUSERS01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTUNDOTBS02.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTSYSAUX01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTUNDOTBS01.DBF C:oracleproduct10.2.0oradataonline;
host copy C:ORACLEPRODUCT10.2.0ORADATATESTSYSTEM01.DBF C:oracleproduct10.2.0oradataonline;

alter database end backup;

--===============================