如需了解Oracle数据泵导入导出请查看

https://www.cnblogs.com/wuhuankang/p/11419318.html

1.首先以dba登录数据库，创建目录并给用户授权（tims为用户名，c:\back为创建的目录）

sqlplus / as sysdba

Create directory back as ‘c:\back‘;

Grant read,write on directory back to tims;

mkdir c:\back

2.备份脚本如下

@echo 开始备份….

@echo 本程序使用zip压缩，备份后的文件可使用rar或者zip解压。

set instanse=orcl

set backpath=c:\test

set mydate=%date:~0,4%%date:~5,2%%date:~8,2%

set username=tims

set password=123123

set extname=rar

set filename=%username%-%mydate%

expdp %username%/%password%@%instanse% schemas=%username% directory=test dumpfile=%filename%.dmp logfile=%filename%.log

"C:\Program Files (x86)\WinRAR\WinRAR.exe" a %filename%.%extname% %filename%.dmp %filename%.log

del %filename%.dmp

del %filename%.log

@echo 备份完毕！

@echo 备份文件为：%filename%.%extname%

@echo 执行sql….

@echo off

echo OK!