windows 下就用任务计划; linux 下就用crontabwindows下的执行脚本例子--backup.bat@echo off if "%time:~0,1%"==" " (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-0%time:~1,1%) else (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-%time:~0,2%) set oralce_sid=mydb rman target sys/sys nocatalog log D:\RmanLog\%backup_file%rman.log append cmdfile=D:\RMAN00_Backup_mydb.rman--rman00_backup_mydb.rmanrun{ configure controlfile autobackup on; configure controlfile autobackup format for device type disk to 'D:\oraclebackup\Ctr00BAK_%F'; configure RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; allocate channel ch01 device type disk format 'D:\oraclebackup\DB00BAK_%d_%T_%U' MAXPIECESIZE 5G; allocate channel ch02 device type disk format 'D:\oraclebackup\DB00BAK_%d_%T_%U' MAXPIECESIZE 5G; backup incremental level=0 database plus archivelog; release channel ch01; release channel ch02; change backup completed before 'sysdate - 7' delete; change archivelog until time 'sysdate - 7' delete; crosscheck backup; report obsolete; delete noprompt expired backup; crosscheck archivelog all; delete noprompt expired archivelog all; } list backup of database;
linux 下就用crontabwindows下的执行脚本例子--backup.bat@echo off
if "%time:~0,1%"==" " (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-0%time:~1,1%) else (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-%time:~0,2%)
set oralce_sid=mydb
rman target sys/sys nocatalog log D:\RmanLog\%backup_file%rman.log append cmdfile=D:\RMAN00_Backup_mydb.rman--rman00_backup_mydb.rmanrun{
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to 'D:\oraclebackup\Ctr00BAK_%F';
configure RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS;
allocate channel ch01 device type disk format 'D:\oraclebackup\DB00BAK_%d_%T_%U' MAXPIECESIZE 5G;
allocate channel ch02 device type disk format 'D:\oraclebackup\DB00BAK_%d_%T_%U' MAXPIECESIZE 5G;
backup incremental level=0 database plus archivelog;
release channel ch01;
release channel ch02;
change backup completed before 'sysdate - 7' delete;
change archivelog until time 'sysdate - 7' delete;
crosscheck backup;
report obsolete;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
}
list backup of database;
我试了一下你给我的例子 运行不出来呢 是不是需要配置什么啊 ?我对Rman知道的很少,麻烦你给我解释一下!