oracle 异机恢复归档日志调试问题

Question

环境:solaris 10 /oracle 9/EMC network 7X
情况:在异机恢复磁带库上的归档日志,调试脚本过程中提示如下:
bash-3.00$ rman cmdfile=res_arch.rcv
Recovery Manager: Release 9.2.0.1.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.
RMAN> connect target [email=backup/backup@portdb]backup/backup@portdb[/email];
2> connect catalog [email=rmanportdb/rmanportdb@xe]rmanportdb/rmanportdb@xe[/email];
3>
4> run
5> {
6>  allocate channel t1 type 'sbt_tape'
7>  parms 'ENV=(NSR_SERVER=fpgbackupserver,NSR_DATA_VOLUME_POOL=Default,NSR_CLIENT=fpserver)';
8>
9>  set archivelog destination to '/export/home/oracle/product/9.2/dbs/arch';
10>
11>  restore archivelog all;
12>
13>
14>
15>
16>
17>  release channel t1;
18>
19> }
20>
21>
connected to target database: PORTDB (DBID=3508279324)
connected to recovery catalog database
allocated channel: t1
channel t1: sid=18 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 20-SEP-09
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2009 00:25:52
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalog
Recovery Manager complete

意思好象是没有相配的archive log在恢复目录里,这个要怎么解,请教各位高手

Answer 1

21号就做出来了,NETWORK下要先恢复controlfile,然后恢复archivelog和数据文件,感谢各位

Answer 2

楼上正解

Answer 3

要不用CATALOG服务器，要不先恢复controlfile

Answer 4

所以还是oracle的catalog好啊，虽然nbu默认是通过脚本备份一遍controlfile，可是恢复的时候还是不如catalog方便

Answer 5

你是说测试备份机上的catalog db吗

Answer 6

有catalog db的话想按照什么顺序restore都可以

Answer 7

请问,从磁带机中进行恢复是否可以在没进行控制文件和数据文件恢复的情况下,先进行归档日志的恢复??

Answer 8

后面经过调试,结果如下:
bash-3.00$ rman cmdfile=res_arch.rcv

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN> connect target backup/backup@portdb;
2> connect catalog rmanportdb/rmanportdb@xe;
3>
4> run
5> {
6>  allocate channel t1 type 'sbt_tape'
7>  parms 'ENV=(NSR_SERVER=fpgbackupserver,NSR_DATA_VOLUME_POOL=Default,NSR_CLIENT=fpserver)';
8>
9>  set archivelog destination to '/export/home/oracle/arch';
10>
11>  restore archivelog all;
12>
13>
14>
15>
16>
17>  release channel t1;
18>
19> }
20>
21>
connected to target database: PORTDB (DBID=3508279324)

connected to recovery catalog database

allocated channel: t1
channel t1: sid=17 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 20-SEP-09

archive log thread 1 sequence 41 is already on disk as file /export/home/oracle/arch/ARCH_1_41.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 20-SEP-09

released channel: t1

Recovery Manager complete.

[ 本帖最后由 cary9999 于 2009-9-20 15:56 编辑 ]