--设置恢复端dbid
set DBID=281386653

select instance_name from v$instance;

--设置恢复端sid

echo $ORACLE_SID

export ORACLE_SID=prod

export ORA_RMAN_SGA_TARGET=350

echo $ORACLE_SID

--启动nomount

startup nomount pfile='/install/s/init.ora'

startup nomount pfile='/home/backup/20150314/init.ora'

'/home/backup/20150314/20150314_PROD_20150314_270_1_CONTROLFILE';

startup upgrade pfile='/home/backup/20150314/init.ora';

ps -ef |grep prod |grep -v grep

startup nomount pfile='/u03/20150314/init.ora'

restore controlfile from '/u03/20150314/20150314_PROD_20150314_270_1_CONTROLFILE';

alter database open resetlogs;

--在rman下恢复controlfile

rman target /

startup nomount 

注意给拷贝过去的文件赋权,否则root读不到

restore spfile to '/install/spfileprod.ora' from '/install/s/20150314_PROD_20150314_271_1_SPFILE';

restore controlfile from '/install/s/20150314_PROD_20150314_270_1_CONTROLFILE';

run{    

set newname for datafile 1 to '/home/oracle/oradata/datafile/system01.dbf';  

set newname for datafile 2 to '/home/oracle/oradata/datafile/undotbs01.dbf';  

set newname for datafile 3 to '/home/oracle/oradata/datafile/sysaux01.dbf';  

set newname for datafile 4 to '/home/oracle/oradata/datafile/users01.dbf';  

set newname for datafile 5 to '/home/oracle/oradata/datafile/example01.dbf';  

set newname for datafile 6 to '/home/oracle/oradata/datafile/gg01.dbf';  

restore database;  

switch datafile all;  

}

recover database using backup controlfile until cancel;

mkdir /u01

 mkdir /u01/oradata

 mkdir /u01/oradata/standby

 mkdir /u01/oradata/prod

 mkdir /home/arch

 mkdir /u01/arch

 mkdir /u01/admin/prod/adump

 mkdir -p /u01/admin/prod/adump

 chown -R oracle:oinstall /u01

 cd /install

export DISPLAY=10.19.11.250:0.0

1）查询到与ORACLE_SID相关的oracle进程

$ ps -ef |grep prod

2）去除掉包含grep命令本身的记录

$ ps -ef |grep prod |grep -v grep

3）使用awk命令得到我们关心的进程号

$ ps -ef |grep prod |grep -v grep|awk '{print $2}'

4）万事俱备，我们最后使用kill命令将oracle的进程杀死，因此得到了下面完整的命令

$ ps -ef |grep prod |grep -v grep|awk '{print $2}' | xargs kill -9