经常做恢复验证，每次都有些小不同，想省点事，搞个一键还原可好？适用于不同实例，源端和目标端好版本一致，平台一致，开始吧。
步骤介绍：
#适用oracle 11g单机环境
#备份在192.168.1.1的RESTORDIR目录下，采用rman备份的多个备份集文件，含参数文件(.par)、控制文件(c-xxx)、全库备份、归档备份
#先清理本地的验证库环境，传备份片过来
#恢复pfile文件后清理参数
#恢复控制文件，注册备份信息
#恢复数据库，调整重做日志
#去掉归档模式
#/bin/bash
# restore database from rman
# please first modify ORACLE_SID and RESTORDIR:
. ~/.bash_profile
RESTORDIR=/oradata/ORCL/20190131
ORACLE_SID=ORCL
export ORACLE_SID=$ORACLE_SID
DBNAME=$ORACLE_SID
dbca -silent -deleteDatabase -sourceDB $DBNAME
RMANDIR=/oradata/rmanbak/$DBNAME
ssh oracle@192.168.1.1 ln -s $RESTORDIR $RMANDIR
BAKDIR=/oradata/$DBNAME/bak
DATADIR=/oradata/$DBNAME/db
rm -fr $BAKDIR/*
rm -fr $DATADIR/*
rm -fr $ORACLE_HOME/dbs/*$DBNAME*
mkdir -p $BAKDIR
mkdir -p $DATADIR
scp 192.168.1.1:$RMANDIR/* $BAKDIR
CMDFILE=/tmp/rman1.txt
PARFILE=`ls $BAKDIR/*.par`
(cat << EOF
startup nomount
restore spfile to pfile '$DATADIR/init.ora' from '$PARFILE';
exit
EOF
)>$CMDFILE
rman target / cmdfile=$CMDFILE
grep -v ".__" $DATADIR/init.ora|grep -v cluster_database|grep -v "_listener"|grep -v "*.log_archive"|grep -v pga_aggregate_target|grep -v sga_max_size|grep -v sga_target|grep -v thread|grep -v control_files >/tmp/init2.ora
grep -v db_cache_size /tmp/init2.ora|grep -v db_create_file_dest|grep -v "*.fal_"|grep -v instance_number|grep -v shared_pool_size>$DATADIR/init.ora
echo "*.control_files=$DATADIR/control01.dbf" >>$DATADIR/init.ora
echo "*.sga_max_size=4G" >> $DATADIR/init.ora
echo "*.sga_target=4G" >> $DATADIR/init.ora
mkdir -p `grep audit_file_dest $DATADIR/init.ora |awk -F "'" '{print $2}'`
CMDFILE=/tmp/rman2.txt
CTLFILE=`ls $BAKDIR/c-*`
(cat << EOF
startup nomount pfile='$DATADIR/init.ora' force
restore controlfile from '$CTLFILE';
alter database mount;
catalog start with '$BAKDIR/' noprompt;
crosscheck backupset;
delete noprompt expired backupset;
exit
EOF
)>$CMDFILE
rman target / cmdfile=$CMDFILE
RMANLOG=/tmp/rman_log_$DBNAME.log
CMDFILE=/tmp/rman_$DBNAME.txt
(cat << EOF
run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
set newname for database to '$DATADIR/%b';
restore database;
switch datafile all;
switch tempfile all;
recover database;
}
exit
EOF
)>$CMDFILE
time nohup rman target / cmdfile=$CMDFILE log=$RMANLOG &
(cat << EOF
set pagesize 9999 lin 250 echo off heading off verify off feedback off trims on
spool /tmp/rename_log.sql
select 'ALTER DATABASE RENAME FILE '''||member||''' to '||''''||'$DATADIR'
||substr(member,instr(member,'/',-1)+1)||''';' cc from v$logfile;
spool off
@/tmp/rename_log.sql
spool /tmp/clear_log.sql
select 'alter database clear logfile group '||group#||';' cc from v$log;
spool off
@/tmp/clear_log.sql
alter database open resetlogs;
--alter database disable thread 2;
--alter database drop logfile group 6,7,8,9,10;
create spfile from pfile='$DATADIR/init.ora';
shutdown immediate
startup mount
alter database noarchivelog;
alter database open;
exit
)>$CMDFILE
sqlplus / as sysdba @$CMDFILE
echo 'game over!'
将上述代码保存为r.sh，放到目标端执行！
基本上修改2处即可：要恢复的实例名和备份文件位置（备份服务器IP地址通常是固定的），
如果没有配置信任关系执行时需要2次输入密码
然后就是喝茶时间啦。
