backup policy

Posted by Arsalan on Jun 18, 2017; 9:52am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/backup-policy-tp2809.html


Sir,

I made rman script for production database kindly check it, does it  right or have some fault ,if need

kindly bring some change on it.

Note:
1)   backup incremental level 0  Run on Wednesday and sunday at 11 pm and

2)   backup incremental level 1 Run on monday tuesday thursday friday saturday every day 11 pm



RMAN> show all;
RMAN configuration parameters for database with db_unique_name orcla are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\APP\ARSLA\FLASH_RECOVERY_AREA\ORCLA\BAKCONTROLFILE\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ARSLA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORCLA.ORA'; # default
---------------------------------------------------------------------------------------------------------------------

RUN {
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
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 FORMAT 'DB_FULL_BACKUP_%D_%M_%Y_%U' DATABASE INCLUDE CURRENT CONTROLFILE TAG 'DB_FULL_BACKUP';
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
}
-------------------------------Incremental level 1 backup
RUN
 {
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
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 FORMAT 'DB_INCR_BACKUP_%D_%M_%Y_%U' DATABASE INCLUDE CURRENT CONTROLFILE TAG 'DB_INCR_BACKUP';
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
}

Note:
1)   backup incremental level 0  Run on Wednesday and sunday at 11 pm and

2)   backup incremental level 1 Run on monday tuesday thursday friday saturday every day 11 pm