COLD BACKUP

TAKE COLD BACKUP AT SOURCE AND COPY IT TO TARGET

++++++++++++++++++++++++++++++++++++++++++++++++++++

$ cat cold_backup.sh

 

export ORACLE_HOME=/dbname/oracle/product/12.1.0.2

export ORACLE_SID=dbname

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

rman target / log=/dbname/wcapp/BACKUP/dbname/dbname`date +%d%m%Y`.log <<EOF

sql 'alter system checkpoint';

shutdown immediate;

startup mount;

sql "create pfile="/dbname/wcapp/BACKUP/dbname/pfile`date +%d%m%Y`.ora" from spfile";

RUN {

ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/dbname/wcapp/BACKUP/dbname/%d_COLD_%M%D%Y_%p_%s';

ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/dbname/wcapp/BACKUP/dbname/%d_COLD_%M%D%Y_%p_%s';

ALLOCATE CHANNEL CH3 DEVICE TYPE DISK FORMAT '/dbname/wcapp/BACKUP/dbname/%d_COLD_%M%D%Y_%p_%s';

ALLOCATE CHANNEL CH4 DEVICE TYPE DISK FORMAT '/dbname/wcapp/BACKUP/dbname/%d_COLD_%M%D%Y_%p_%s';

BACKUP AS COMPRESSED BACKUPSET FULL DATABASE TAG dbname_cold_backup_dbfiles;

BACKUP FORMAT '/dbname/wcapp/BACKUP/dbname/%d_%M_%D_%Y_%t.ctl' CURRENT CONTROLFILE TAG dbname_backup_ctlfile;

RELEASE CHANNEL disk1;

RELEASE CHANNEL disk2;

RELEASE CHANNEL disk3;

}