oracle9i数据库:Windows下Oracle9i数据库文件的自动备份来源: 发布时间:星期五, 2009年2月20日 浏览:0次 评论:0
="t18">
第
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() export ORACLE_HOME . /opt/oracle/product/.bash_profile export DATE=$(date +%Y%m%d) # ![]() ![]() ![]() ![]() /opt/oracle/product/9.0.2/bin/exp goldring/123456@szdb file=/data/OracleDB_Backup/goldring.dmp log=/data/OracleDB_Back up/loggoldring.dmp consistent=yes /opt/oracle/product/9.0.2/bin/exp jltgame/123456@szdb file=/data/OracleDB_Backup/jltgame$DATE.dmp log=/data/OracleDB_Ba ckup/logjltgame.dmp consistent=yes /opt/oracle/product/9.0.2/bin/exp userid=oraclebackup/"abcd456&*("@szdb owner=moonprincess file=/data/OracleDB_Backup/moon princess.dmp log=/data/OracleDB_Backup/logmoonprincess.dmp consistent=yes #FTP -n 10.0.0.3 < /opt/oracle/product/movedata/ftpcommand 把以上脚本放到crontab中即可 注:oracle实现自动备份要害是要在备份脚本中加入oracle ![]() 0
相关文章读者评论发表评论 |