python oracle数据库备份脚本
学习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()
|
执行结果：
本文转自 koumm 51CTO博客，原文链接：http://blog.51cto.com/koumm/1438673，如需转载请自行联系原作者