http://database.51cto.com/art/201108/286237.htm
Linux系统下Oracle数据库的备份:
- FIELNAME=/home/oracle/dmp/`date +%Y%m%d`.dmp
- echo $FIELNAME > /home/oracle/dmp/filename
- /home/oracle/product/9.2/bin/exp ccbip/'und\=2008CN(Y|N)' full=y file=$FIELNAME
- bzip2 $FIELNAME
注:创建的文件都是Oracle用户oinstall组的。
Windows系统下Oracle数据库自动备份脚本:
expData.bat的内容:
- exp system/system@orcl file=c:\oracle_bak\tne%date:~4,10%.dmp owner=tne
- exp system/system@orcl file=c:\oracle_bak\prt%date:~4,10%.dmp owner=prt
- exp system/system@orcl file=c:\oracle_bak\sec%date:~4,10%.dmp owner=sec
- exp system/system@orcl file=c:\oracle_bak\tea%date:~4,10%.dmp owner=tea
- exp system/system@orcl file=c:\oracle_bak\pic%date:~4,10%.dmp owner=pic
- exp system/system@orcl file=c:\oracle_bak\system%date:~4,10%.dmp owner=system
- path=D:\WinRAR 3.20
- rar a Data%date:~4,10%.rar *%date:~4,10%.dmp
- del *%date:~4,10%.dmp
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-730889/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17252115/viewspace-730889/