nbu重定向恢复oarcle单实例

在源主机A做数据库fox的nbu备份
可以在master sever上通过添加policy来做，也可以在A机上
启动A的backup,Arcive and Restore界面，按提示一步步操作，主要有如下几步：

执行恢复时，（纳闷的是同机恢复可以在A的图形界面做，重定向在文档上居然找不到界面操作的相关说明）
切换到目的主机B
拷贝A的pfile，新建fox的sid，新建pwd文件，catalog的net连接
>set oracle_sid=fox
>rman target / catalog rman/rman@mycata
rman>startup nomount
rman>run
{
# Allocates tape channel and sets RMAN environment variable
allocate channel t1 type 'SBT_TAPE'
parms="ENV=(NB_ORA_CLIENT=A,NB_ORA_SERV=SVRTEST1)";
restore
(database);
restore
controlfile to 'D:\oracle\oradata\fox\control01.ctl';
release channel t1;
}
拷贝control01.ctl，生成control02.ctl
rman>alter database mount;
>recover database using backup controlfile;
系统报错
>recover database using backup controlfile until cancel;
因为目的库的归档和主库没有同步，所以在要求提供没有的归档时输入cancel
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2461622981 generated at 02/14/2011 16:01:50 needed for thread
1
ORA-00289: suggestion : D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00018.001
ORA-00280: change 2461622981 for thread 1 is in sequence #18


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.
>alter database open resetlogs;
至此恢复完成