Chinaunix

标题: oracle 10g rac rman (TSM) 恢复报错 [打印本页]

作者: mikerzhu 时间: 2006-12-05 13:39
标题: oracle 10g rac rman (TSM) 恢复报错
Hi，
rman恢复报错，请各位大侠帮忙看看：
ora10g1.log_archive_dest='/redolog15'
ora10g2.log_archive_dest='/redolog30'
(或者
ora10g1.log_archive_dest_1='location=/redolog15'
ora10g2.log_archive_dest_1='location=/redolog30')
p615: SID=ora10g1  归档日志目录/redolog15
p630: SID=ora10g2  归档日志目录/redolog30

rman脚本
run
{
startup mount;
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'connect *;
allocate channel t2 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'connect *;
restore database;
recover database;

release channel t1;
release channel t2;
alter database open resetlogs;
}
Oracle 10g RAC 双机archivelog分别放在本地目录/redolog15和/redolog30下，然后两边分别nfs(mount)对方的归档日志目录(可读可写权限).
p630# nfsstat -m
/redolog15 from /redolog15:p615
Flags: vers=3,proto=tcp,auth=unix,hard,intr,link,symlink,rsize=32768,wsize=32768,retrans=5
All:    srtt=0 (0ms), dev=0 (0ms), cur=0 (0ms)

p615# nfsstat -m
/redolog30 from /redolog30:p630
Flags: vers=3,proto=tcp,auth=unix,hard,intr,link,symlink,rsize=32768,wsize=32768,retrans=5
All:    srtt=0 (0ms), dev=0 (0ms), cur=0 (0ms)

p630# mount
  node    mounted       mounted over vfs    date       options
      /dev/fslv04    /redolog30    jfs2 Dec 05 09:29 rw,log=/dev/loglv00
p615    /redolog15    /redolog15    nfs3 Dec 05 12:32 rw

p615# mount
  node    mounted       mounted over vfs    date       options
-------- ---------------  ---------------  ------ ------------ ---------------

      /dev/fslv03    /redolog15    jfs2 Dec 05 12:11 rw,log=/dev/loglv00
p630    /redolog30    /redolog30    nfs3 Dec 05 12:29 rw

在/redolog15和/redolog30目录中相互拷贝文件没有问题.

rman恢复报错报错

starting media recovery

archive log thread 2 sequence 2 is already on disk as file /redolog30/2_2_608309345.dbf
archive log thread 2 sequence 3 is already on disk as file /redolog30/2_3_608309345.dbf
archive log filename=/redolog30/2_2_608309345.dbf thread=2 sequence=2
channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=3
channel t1: restoring archive log
archive log thread=1 sequence=4
channel t1: reading from backup piece arch_608310869_7_%r.log
channel t1: restored backup piece 1
piece handle=arch_608310869_7_%r.log tag=TAG20061204T151356
channel t1: restore complete, elapsed time: 00:00:01
archive log filename=/redolog15/1_3_608309345.dbf thread=1 sequence=3
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/04/2006 17:32:05
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/redolo
g15/1_3_608309345.dbf'
ORA-00308: cannot open archived log '/redolog15/1_3_608309345.dbf'
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6

作者: david5337 时间: 2006-12-05 20:31
貌似这个归档文件没有恢复回来的样子哦

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)