Friday, April 01, 2011

RMAN Restore Datafile



Steps:
1. identify datafile#  to be recoved
2. plug in the value the restore script
3. execute restore.sh

# rman_file_recover.cmd
run {
  allocate channel t1 type sbt;
  restore datafile 4;
  recover datafile 4;
}

# restore.sh
. ~/.profile
ORACLE_SID=demo;ORAENV_ASK=NO;. oraenv;ORAENV_ASK=YES
cd /ora01/oracle/admin/BACKUP/WKBP
rman nocatalog target / cmdfile rman_file_recover.cmd
status=$?
exit $status
Hope this helps!Rupam