python oracle数据库备份脚本

eff33

学习python,将shell备份脚本改成了python脚本练手.python oracle备份脚本一例如下。

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

#!/usr/bin/env python   # -*- coding: utf-8 -*- import time import os #配置oracle环境变量参数 os.environ["NLS_LANG"] = "Simplified Chinese_china.ZHS16GBK" os.environ['ORACLE_HOME'] = '/u01/app/oracle/product/10.2.0/db_1' os.environ['PATH'] = "/u01/app/oracle/product/10.2.0/db_1/bin" + ":" + os.environ['PATH'] os.environ['ORACLE_SID'] = "orcl" os.environ['LANG'] = "en_US" #打印提示信息。 exp_node1 = "\n成功备份文件到目录...." exp_node2 = "备份失败" cls_node1 = "数据库备份数据清除成功,删除语句如下...." cls_node2 = "数据库备份清除失败" #配置导出的数据库信息 data_path = '/tmp/' db_username = 'abc' db_password = 'abc' db_name = 'abc' """ print os.getenv('NLS_LANG') print os.getenv('ORACLE_HOME') print os.getenv('ORACLE_SID') """ def oracle_exp():      exp_command = "exp %s/%s file=%s%s_%s-%s-%s_%s%s%s.dmp log=%s%s_%s-%s-%s_%s%s%s.log"  % (db_username,db_password,data_path,db_name,time.strftime('%Y'),time.strftime('%m'),time.strftime('%d'),time.strftime('%H'),time.strftime('%M'),time.strftime('%S'),data_path,db_name,time.strftime('%Y'),time.strftime('%m'),time.strftime('%d'),time.strftime('%H'),time.strftime('%M'),time.strftime('%S'))      exp_note = "数据库备份执行语句...."      print "\033[1;31;40m%s\033[0m" %  exp_note      print "\033[1;31;40m%s\033[0m" %  exp_command      if os.system(exp_command) == 0:         print "\033[1;32;40m%s\033[0m" % exp_node1      else:         print "\033[1;31;40m%s\033[0m" % exp_node2 def backup_clear():      cls_command1 = '/usr/bin/find %s -mtime +1 -name "*.dmp" -exec rm -rf {} \;' % data_path      cls_command2 = '/usr/bin/find %s -mtime +1 -name "*.log" -exec rm -rf {} \;' % data_path      if os.system(cls_command1) == 0 and os.system(cls_command2) == 0:         print "\n\033[1;32;40m%s\033[0m" % cls_node1      else:         print "\n\033[1;31;40m%s\033[0m" % cls_node2      print "%s" % cls_command1      print "%s\n" % cls_command2 def main():      oracle_exp()      backup_clear() if __name__ == "__main__":      main()

执行结果：