由於之前寫rman 指令碼的時候需要手動去修改一些路徑很麻煩，沒辦法做此指令碼方便大家。注此指令碼使用前提資料庫已經mount,也就是已經恢復了引數檔案及控制檔案

點選(此處)摺疊或開啟

#Decription: general rman scription
#Author by:netdata
#Date:2015-07-17
#!/bin/bash
$ORACLE_HOME/bin/sqlplus -s " / as sysdba" <<eof >file1.log
set head off;
set feedback;
select name from v\$datafile;
exit;
eof
#
for file in `cat file1.log`; do
file=`basename $file`;
echo "'"'/oradata/xyxdb/xyxdb/'$file"'">>newfile.log;
done
#
for file in `cat file1.log`; do
echo "'"$file"'">>newfile1.log;
done
#
while read -u3 i && read -u4 j;do
echo " set newname for datafile "$i" to "$j";">>rman1.log;
done 3<newfile1.log 4<newfile.log
#
$ORACLE_HOME/bin/sqlplus -s " / as sysdba" <<eof >maxsn.log
set head off;
set feedback;
select * from (select next_change# from v\$archived_log order by next_change# desc) where rownum=1;
exit;
eof
#
#生成rman指令碼
max_sn=`sed -e 's/^[ \t]*//g' maxsn.log | grep -v '^$'`
echo $max_sn
awk 'BEGIN{print"run {"}END{print "restore database;";print "switch datafile all;";print "recover database until scn '$max_sn';";print "}"}1' rman1.log>restore.rman
rm -rf newfile.log newfile1.log rman1.log file1.log
#rman nocatalog target / cmdfile=restore.rman log restore`date +%Y%m%d`.log

rman 異機恢復指令碼(路徑不一致)

相關文章