数据备份脚本

 

backup_0.bat  启动脚本

backup_0.cmd 全备份

backup_1.bat  启动脚本

backup_1.cmd 增量备份

delete.bat        删除备份

ftp.bat             ftp传输脚本

myftp.txt 传输数据库备份文件

recover.bat      启动脚本

recover.cmd    数据恢复

 

                                                                                         

backup_0.bat 放在计划任务中定期执行

rem run rman

rman cmdfile=e:/script/backup_0.cmd

 

backup_0.cmd

connect target sys/xingye@ofs1_localhost;

backup incremental level 0 format='E:/backupdata/%d_%s.dbf' database;

sql 'alert system archive log current';

                                                                                       

                                                                                      

backup_1.bat

rem run rman

rman cmdfile=e:/script/backup_1.cmd

 

backup_1.cmd

connect target sys/xingye@ofs1_localhost;

backup incremental level 1 format='E:/backupdata/%d_%s.dbf' database;

sql 'alert system archive log current';

                                                                                      

                                                                                      

delete.bat

del /q e:/backupdata

                                                                                   

                                                                                   

ftp.bat      启动ftp

c:/windows/system32/ftp.exe -i -n -s:"e:/script/myftp.txt"

 

myftp.txt

ftp

open 114.255.97.233

user test 111

lcd e:/backupdata 

Binary     

mput *.*    

Bye

                                                                                   

                                                                                    

recover.bat

rem run rman

rman cmdfile=e:/script/recover.cmd

 

recover.cmd

connect target sys/xingye@ofs1_localhost;

    startup force mount;

    restore database;

    recover database;

   sql 'alter database open' ;