自动备份oracle数据库方法

建bat文件,写入runScript.vbs

建runScript.vbs文件内容如下,user为用户名,password为密码sid为服务名

Option Explicit

On Error Resume Next

Dim fname, cmd
Dim WshShell

Set WshShell = CreateObject("WScript.Shell")

fname = Date
cmd = "exp userid=user/password@sid owner=cc log=./backup/" & fname & "_bak.log file=./backup/" & fname & "_bak.dmp"

WshShell.run cmd

Set WshShell = Nothing

'WScript.Echo cmd

 

最后把bat文件加入到控制面版里的任务计划里