oeacle 按用户自动备份

放在bat里面,每天备份一次,七天后删除第一个备份记录

 

@echo off
echo  %date% %time% 备份 >>log.txt
if not exist d:/htjz/htjz7.dmp echo "没有文件d:/htjz/htjz7.dmp" >> log.txt
del d:/htjz/htjz7.dmp
del d:/htjz/htjz7.log
if not exist d:/htjz/htjz6.dmp echo "没有文件d:/htjz/htjz6.dmp" >> log.txt
ren d:/htjz/htjz6.dmp htjz7.dmp
ren d:/htjz/htjz6.log htjz7.log
if not exist d:/htjz/htjz5.dmp echo "没有文件d:/htjz/htjz5.dmp" >> log.txt
ren d:/htjz/htjz5.dmp htjz6.dmp
ren d:/htjz/htjz5.log htjz6.log
if not exist d:/htjz/htjz4.dmp echo "没有文件d:/htjz/htjz4.dmp" >> log.txt
ren d:/htjz/htjz4.dmp htjz5.dmp
ren d:/htjz/htjz4.log htjz5.log
if not exist d:/htjz/htjz3.dmp echo "没有文件d:/htjz/htjz3.dmp" >> log.txt
ren d:/htjz/htjz3.dmp htjz4.dmp
ren d:/htjz/htjz3.log htjz4.log
if not exist d:/htjz/htjz2.dmp echo "没有文件d:/htjz/htjz2.dmp" >> log.txt
ren d:/htjz/htjz2.dmp htjz3.dmp
ren d:/htjz/htjz2.log htjz3.log
if not exist d:/htjz/htjz.dmp echo "没有文件d:/htjz/htjz.dmp" >> log.txt
ren d:/htjz/htjz.dmp htjz2.dmp
ren d:/htjz/htjz.log htjz2.log

exp htjzdba/htjzfhit123@orcl2205 owner='HTJZDBA' file=d:/htjz/htjz.dmp log=d:/htjz/htjz.log  

 

 

有什么问题欢迎大家指出

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值