Re: backup policy

Posted by Arsalan on Jul 04, 2017; 1:44pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/backup-policy-tp2809p2885.html


Sir,

I changed the script so kindly recheck if their any mistake


Thanks in advance

---Incremental level 0 backup

RUN {
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
CROSSCHECK BACKUPSET DEVICE TYPE DISK;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
ALLOCATE CHANNEL CH1 TYPE DISK;
ALLOCATE CHANNEL CH2 TYPE DISK;
ALLOCATE CHANNEL CH3 TYPE DISK;
BACKUP INCREMENTAL LEVEL 0 FILESPERSET 1 DATABASE PLUS ARCHIVELOG FORMAT 'C:\app\arsla\flash_recovery_area\orcla\ARCHIVEBK\arch_%d_%T_%s_%t'
DELETE ALL INPUT;
DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
DELETE BACKUP COMPLETED BEFORE 'SYSDATE -7';
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
}

-------------------------------Incremental level 1 backup
RUN
 {
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
CROSSCHECK BACKUPSET DEVICE TYPE DISK;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
ALLOCATE CHANNEL CH1 TYPE DISK;
ALLOCATE CHANNEL CH2 TYPE DISK;
ALLOCATE CHANNEL CH3 TYPE DISK;
BACKUP INCREMENTAL LEVEL 1 FILESPERSET 1 DATABASE PLUS ARCHIVELOG FORMAT 'C:\app\arsla\flash_recovery_area\orcla\ARCHIVEBK\arch_%d_%T_%s_%t'
DELETE ALL INPUT;
DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
DELETE BACKUP COMPLETED BEFORE 'SYSDATE -7';
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
}