Database Technologies...!

Came up with this very simple script to automate the restore of control file from given backup. This was to answer a question posted on OTN, https://community.oracle.com/message/13668456#13668456 [oracle@prima ~]$ cat cnt_rst.sh export ORACLE_HOME=/orahome/product/11.2.0/dbhome_1 export ORACLE_SID=DG1 bdate=20151214 rman target / cmdfile='to_os.scr' log='os_file.txt' #bpc=`cat os_file.txt | grep -i $bdate | grep -i ncnn | cut -d '/' -f 2-` - to restore from piece bpc=`cat os_file.txt | grep -i 20151214 | grep -i tag: | awk '{print $NF}'` echo "run {" >> rst_cnt.scr #echo "restore controlfile to '/home/oracle/cnt_$bdate.cnt' from '/$bpc';" >> rst_cnt.scr - to restore from piece echo "restore controlfile to '/home/oracle/cnt_$bdate.cnt' from tag $bpc;" >> rst_cnt.scr echo "}" >> rst_cnt.scr rman target / cmdfile='rst_cnt.scr...

This is a 10 step guide on restoring/recovering a set tablespaces on different server from RMAN full backup. OS – RHEL -4 DB - 10.2.0.4.0 Step 1 – Start from dummy parameter file RMAN> startup force Step 2 – Restore spfile from backup set RMAN> restore spfile from '<FULL_PATH_TO_BACKUP_PIECE>'; Here you can find the backup piece containing parameter file by looking at the backup log or simply it is the smallest backup piece in backupset. Step 3 – Create pfile from spfile and do the required changes SQL> create pfile from spfile; After creating the pfile you can edit the settings of parameters so that it   would   suite the new server. Most of these parameter values are PATHs that need to be changed according to new server Oracle Home. 1.audit_file_dest 2.background_dump_dest 3.control_files 4.core_dump_dest 5.log_archive_dest_1 6.user_dump_dest Step 4 – Create spfile from pfile, Shut Down, Startup Nomount SQL...