论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-09-20 00:31 |只看该作者 |倒序浏览

环境: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在恢复目录里,这个要怎么解,请教各位高手

恢复, 恢复

文库|博客

cary9999

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2009-09-20 01:18 |只看该作者

后面经过调试,结果如下:
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 编辑 ]