Wednesday, July 4, 2012

RMAN Script for incremental level 0 backup of database plus archivelogs and controlfile


#!/bin/ksh
export DATE=$(date +%Y-%m-%d)
rman target / msglog
/u05/rmgc/dailybackup/RMGC/backupset/rman_full_backup_db_online_PROD1_${DATE}.log
<
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK FORMAT
'/u05/rmgc/dailybackup/RMGC/backupset/23_03_2012/%d_DB_%u_%s_%p';
backup
filesperset 4
 INCREMENTAL LEVEL 0 AS COMPRESSED BACKUPSET database include current
controlfile;
sql "alter system archive log current";
backup
filesperset 4
AS COMPRESSED BACKUPSET archivelog all format
'/u05/rmgc/dailybackup/RMGC/backupset/23_03_2012/al_%U' delete input;
RELEASE CHANNEL ch1;
}
EXIT;
EOF
exit;

No comments:

Post a Comment