请教windows2003,oracle 7天增量备份SQL脚本
RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR
DEVICE TYPE DISK TO 'C:\BACKUP\%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT
'C:\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;
上面这个是全备份的。如何写增量的? 帮忙贴个完整带注释的。初学数据库,希望大家能帮帮我。谢谢了。