windows部分联机自动备份脚本！

最新推荐文章于 2024-09-30 09:09:52 发布

clt3617

最新推荐文章于 2024-09-30 09:09:52 发布

阅读量89

点赞数

文章标签：数据库

c:dbbak.bat

dbbak.bat内容如下：

sqlplus / as sysdba @ dbbak.sql

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

[@more@]

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

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;

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1008350/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1008350/