python同步oracle_python定时备份oracle数据库上传到ftp

利用python定时备份数据库并上传到ftp，代码：

import os;

import time;

import tarfile;

import shutil;

import ftplib;

import datetime

dumpdir = 'D:/oraclebak/';#oracle dmp的存储路径

tardir = 'D:/dumptar/'

dbList = ('user1','user2','user3');#oralce用户

ftpdir = '/ftp/dump/';#ftp存储路径

##循环执行oracle备份命令

for dbname in dbList:

command = "expdp userid='sys/syshaha@localhost/orcl as sysdba' \

directory=DUMP_DIR dumpfile=%s.dmp,logfile=%s.log schemas=%s" %(dbname,dbname,dbname);

os.system(command);

tar_file = time.strftime('%Y-%m-%d_%H-%M-%S')+'.tar.gz';#创建tar文件

tar = tarfile.open(tardir+tar_file,'w:gz');

##循环将dmp文件压缩到tar文件，然后删除dmp文件

for root,dir,files in