1、基本信息
备份数据存储目录:D:\DatabaseBackup\bakData
数据库程序主目录:D:\app\Administrator\product\11.2.0\dbhome_1\
备份机制:使用rman工具备份,每天进行全库备份,备份保留7天
2、备份脚本
备份脚本如下:
rman.bat 运行此脚本进行数据库备份(记得要添加任务计划,每天运行这个脚本)
set ORACLE_SID=orcl
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\rman target / CMDFILE 'D:/DatabaseBackup/bakScript/orabackup.txt' LOG 'D:/DatabaseBackup/bakData/backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%.log'
orabackup.txt 此脚本供rman.bat调用