Posts

Showing posts with the label Oracle 11g:RMAN Backup Database in NOARCHIVELOG MODE:Mount state

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

Image
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; AL...