Monday 2 February 2015

Basic RMAN backup / Basic Archive backup

- Simple RMAN backup / RMAN Basic backup - Simple Archive backup / Simple Archivelog backup 1. For first time RMAN backup, do some basic checks / config changes CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXOPENFILES 4 MAXPIECESIZE 5G FORMAT '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_b_%T_%u_%s_%p' RATE 15 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXOPENFILES 4 MAXPIECESIZE 5G FORMAT '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_b_%T_%u_%s_%p' RATE 15 M; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_cf_%F'; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_snapcf.f'; show all; 2. Here is a backup script DATELOG_ID=`date '+%Y%m%d%H%M'` rman target / <>log_rman_${DATELOG_ID}.txt show all; crosscheck archivelog all; backup incremental level=0 database plus archivelog delete input; EOF 3. Here is a basic ARCHIVE backup script DATELOG_ID=`date '+%Y%m%d%H%M'` rman target / <>log_rman_${DATELOG_ID}.txt show all; crosscheck archivelog all; backup archivelog all delete input; EOF