任务:在windows2003 + oracle9i 数据库服务器上,进行备份。
主要文件及内容如下:[@more@]
rman_crm.bat
rman_crm_cmd.txt
rman_crm.bat 的内容
set DB_USERNAME=%1%
set DB_PASSWORD=%2%
set TNS_ALIAS=%3%
set CMDFILE=... 隐藏
set LOGFILE=... 隐藏
rman target %DB_USERNAME%/%DB_PASSWORD%@%TNS_ALIAS% nocatalog cmdfile=%CMDFILE% msglog %LOGFILE%
rman_crm_cmd.txt 的内容
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK
FORMAT 'C:oracleackupCRM%d_DB_%u_%s_%p';
BACKUP DATABASE PLUS ARCHIVELOG;
RELEASE CHANNEL ch1;
}
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete redundancy=2;
EXIT;
测试通过后,加入了WINDOWS在任务计划中。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/271063/viewspace-970920/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/271063/viewspace-970920/