RUN { DELETE NOPROMPT BACKUP; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F'; ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U'; BACKUP DATABASE SKIP INACCESSIBLE PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT; RELEASE CHANNEL C1; }
RUN { DELETE NOPROMPT BACKUP; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F'; ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U'; BACKUP DATABASE SKIP INACCESSIBLE PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT; RELEASE CHANNEL C1; }
-- 编写RMAN批处理文件: RUN { DELETE NOPROMPT BACKUP; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F'; ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U'; BACKUP DATABASE SKIP INACCESSIBLE PLUS ARCHIVELOG FILESPERSET 20 DELETE ALL INPUT; RELEASE CHANNEL C1; } ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; CROSSCHECK BACKUPSET; DELETE NOPROMPT OBSOLETE;-- 保存至D:\oracle\script\backup\db_fullbak_sztyora.rman。-- 然后设置任务计划每天什么时候调用脚本D:\oracle\script\backup\db_fullbak_sztyora.rman执行就可以啦!
如果是要删除以前备份,可以使用RMAN。
DELETE NOPROMPT BACKUP;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U';
BACKUP DATABASE SKIP INACCESSIBLE
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL C1;
}
DELETE NOPROMPT BACKUP;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U';
BACKUP DATABASE SKIP INACCESSIBLE
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL C1;
}
RUN {
DELETE NOPROMPT BACKUP;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ORACLE\BACKUP\%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT 'D:\ORACLE\BACKUP\BAK_%U';
BACKUP DATABASE SKIP INACCESSIBLE
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL C1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;-- 保存至D:\oracle\script\backup\db_fullbak_sztyora.rman。-- 然后设置任务计划每天什么时候调用脚本D:\oracle\script\backup\db_fullbak_sztyora.rman执行就可以啦!