Oracle Exadata DB backup on ZFS
Oracle Exadata DB backup on ZFS.
Exadata Database backup on ZFS Storage Appliance. It is similar to normal disk backup.
| # Script Name: bkp_Full_Inc0_ORADW1_01.sh #!/bin/ksh export BASEDIR=’/home/oracle’ export ORACLE_SID=ORADW11 export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export DT=`date +”%m_%d_%y_%H_%M”` export LOGFILE=bkp_incr_0_${ORACLE_SID}_${DT}.log echo “Backup started at ” `date` > $BASEDIR/bkp_${ORACLE_SID}_incr0_${DT}.log1 rman target=/ catalog rman12c/*****@rman<<EOF >>$BASEDIR/${LOGFILE} run { sql ‘alter system set “_backup_disk_bufcnt”=64 scope=memory’; sql ‘alter system set “_backup_disk_bufsz”=1048576 scope=memory’; allocate CHANNEL ch1 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup01/ORADW1/bk_%d_%s_%p_%t’ ; allocate CHANNEL ch2 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup03/ORADW1/bk_%d_%s_%p_%t’ ; allocate CHANNEL ch3 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup01/ORADW1/bk_%d_%s_%p_%t’ ; allocate CHANNEL ch4 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup03/ORADW1/bk_%d_%s_%p_%t’ ; allocate CHANNEL ch5 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup01/ORADW1/bk_%d_%s_%p_%t’ ; allocate CHANNEL ch6 DEVICE TYPE DISK FORMAT ‘/zfssa/prod/backup03/ORADW1/bk_%d_%s_%p_%t’ ; delete noprompt backup completed before ‘sysdate-40′ device type disk; crosscheck backup; crosscheck archivelog all; backup incremental level 0 section size 30G AS BACKUPSET database TAG=’ORADW_DBFULL_BKP_$DT’; backup current controlfile; backup archivelog all tag=’ORADW_DB_ARCH_$1_bkp’ delete input; release channel ch1; release channel ch2; release channel ch3; release channel ch4; release channel ch5; release channel ch6; } EXIT EOF if [ $? = 0 ] then echo “Backup Ended at ” `date` >> $BASEDIR/${LOGFILE} else echo “Backup FAILED at ” `date` >> $BASEDIR/${LOGFILE} fi $ |
See also: