#!/bin/bash export NB_ORA_CLIENT=rome_pres-bu export ORACLE_SID=iwhprod export ORACLE_HOME=/u01/app/oracle/product/10.2.0.5.0/db_1 export LD_LIBRARY_PATH=$ORACLE_HOME:/lib:/usr/lib:/usr/ccs/lib export PATH=$ORACLE_HOME/bin:$PATH /u01/app/oracle/product/10.2.0.5.0/db_1/bin/rman target '/' nocatalog << EOF > /usr/openv/netbackup/scripts/iwhprod_restore.log run { ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_CLIENT=rome_pres-bu'; ALLOCATE CHANNEL CH02 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_CLIENT=rome_pres-bu'; ALLOCATE CHANNEL CH03 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_CLIENT=rome_pres-bu'; ALLOCATE CHANNEL CH04 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_CLIENT=rome_pres-bu'; restore controlfile from '/u01/app/oracle/product/10.2.0.5.0/db_1/dbs/iwhprod_bkup_control_db.20180120090005'; sql 'alter database mount'; restore database; recover database; release CHANNEL CH01; release CHANNEL CH02; release CHANNEL CH03; release CHANNEL CH04; } EOF exit;