Sunday, July 13, 2014

Oracle 11g:RMAN Backup Database in NOARCHIVELOG MODE:Mount state

Oracle 11g:RMAN Backup Database in NOARCHIVELOG MODE




Dear User,

Today we'll see how to take rman compressed backup when database in noarchivelog mode.

For that ,Database should be in mount state because database needs to be in consistent state for taking compressed full backup where no changes happened during backup.


1.Use below script.

vi RMAN_DBEXPERT_COMPRESSED_LO.sh

export ORATAB=/etc/oratab

export ORACLE_BASE=/orahome/11.2.0.4

export ORACLE_HOME=/orahome/11.2.0.4/product/11.2.0.4/

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=dbexport

touch /rman/Offline/dbexpert_rman/bckstart.time

sleep 60

ddy=`date +%a`

dt=`date +%Y%m%d`

echo "Backup Started on `date`" > /rman/Offline/dbexpert_rman/${dt}_${ddy}_dbexpert_lvl0.log



rman target / trace /rman/Offline/dbexpert_rman/${dt}_${ddy}_dbexpert_lvl0.log  << EOF

RUN {

ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk2 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk3 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk4 DEVICE TYPE DISK;

ALLOCATE CHANNEL disk5 DEVICE TYPE DISK;

SHUTDOWN IMMEDIATE

STARTUP MOUNT


backup as compressed backupset incremental level 0 FORMAT '/rman/Offline/dbexpert_rman/%T_${ddy}_lvl0_%d_%U.%p' database maxsetsize 30G;

release channel disk1;

release channel disk2;

release channel disk3;

release channel disk4;

release channel disk5;

ALLOCATE CHANNEL disk3 DEVICE TYPE DISK;

backup format '/rman/Offline/dbexpert_rman/%T_${ddy}_lvl0_Controlfile_%s.ctl' current controlfile;

backup format '/rman/Offline/dbexpert_rman/%T_${ddy}_lvl0_Spfile_%s.ora' spfile;

report schema;

}

EOF

touch /rman/Offline/dbexpert_rman/ftp.time

exit;


2. Run in background.Check db is running.

nohup sh RMAN_DBEXPERT_COMPRESSED_LO.sh &


No comments:

Post a Comment

Dear User,

Thank you very much for your kind response