RMAN restore时错误 RMAN-10038

ShineCQY

rman restore时日志信息
channel d1: reading from backup piece /bw/bw_full_84_1.dbf
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /oradata/BWP/sr3.data2
restoring datafile 00007 to /oradata/BWP/sr3.data4
restoring datafile 00008 to /oradata/BWP/sr3700.data1
restoring datafile 00009 to /oradata/BWP/sr3700.data2
restoring datafile 00010 to /oradata/BWP/sr3700.data3
restoring datafile 00012 to /oradata/BWP/sr3usr.data1
restoring datafile 00014 to /oradata/BWP/sr3.data5
restoring datafile 00015 to /oradata/BWP/sysaux.data2
restoring datafile 00017 to /oradata/BWP/sr3.data7
restoring datafile 00019 to /oradata/BWP/sr3.data8
restoring datafile 00021 to /oradata/BWP/sr3.data10
restoring datafile 00023 to /oradata/BWP/sr3.data12
restoring datafile 00025 to /oradata/BWP/sr3.data14
restoring datafile 00027 to /oradata/BWP/sr3.data16
restoring datafile 00029 to /oradata/BWP/sr3.data18
restoring datafile 00031 to /oradata/BWP/sr3.data20
restoring datafile 00032 to /oradata/BWP/system.data2
restoring datafile 00034 to /oradata/BWP/sr3.data22
restoring datafile 00036 to /oradata/BWP/sr3.data24
restoring datafile 00038 to /oradata/BWP/sr3.data26
channel d2: reading from backup piece /bw/bw_full_85_1.dbf
channel d1: restored backup piece 1
failover to piece handle=/oradata/bw/bw_full_84_1.dbf tag=TAG20120521T121947
channel d1: reading from backup piece /bw/bw_full_84_2.dbf
released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/26/2012 16:36:12
RMAN-10038: database session for channel d1 terminated unexpectedly
重新运行继续报错
channel d1: reading from backup piece /bw/bw_full_84_1.dbf
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /oradata/BWP/sr3.data2
restoring datafile 00007 to /oradata/BWP/sr3.data4
restoring datafile 00008 to /oradata/BWP/sr3700.data1
restoring datafile 00009 to /oradata/BWP/sr3700.data2
restoring datafile 00010 to /oradata/BWP/sr3700.data3
restoring datafile 00012 to /oradata/BWP/sr3usr.data1
restoring datafile 00014 to /oradata/BWP/sr3.data5
restoring datafile 00015 to /oradata/BWP/sysaux.data2
restoring datafile 00017 to /oradata/BWP/sr3.data7
restoring datafile 00019 to /oradata/BWP/sr3.data8
restoring datafile 00021 to /oradata/BWP/sr3.data10
restoring datafile 00023 to /oradata/BWP/sr3.data12
restoring datafile 00025 to /oradata/BWP/sr3.data14
restoring datafile 00027 to /oradata/BWP/sr3.data16
restoring datafile 00029 to /oradata/BWP/sr3.data18
restoring datafile 00031 to /oradata/BWP/sr3.data20
restoring datafile 00032 to /oradata/BWP/system.data2
restoring datafile 00034 to /oradata/BWP/sr3.data22
restoring datafile 00036 to /oradata/BWP/sr3.data24
restoring datafile 00038 to /oradata/BWP/sr3.data26
channel d2: reading from backup piece /bw/bw_full_85_1.dbf
ORA-19870: error reading backup piece /oradata/bw/bw_full_84_1.dbf
ORA-19504: failed to create file "/oradata/BWP/sr3.data1"
ORA-27086: unable to lock file - already in use
HPUX-ia64 Error: 13: Permission denied
Additional information: 8
Additional information: 8662
数据库以及系统信息
SQL*Plus: Release 10.2.0.2.0 - Production on Sat May 26 16:46:15 2012
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
rman target /
Recovery Manager: Release 10.2.0.2.0 - Production on Sat May 26 16:46:47 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: BWP (DBID=2593359771, not open)
uname -a
HP-UX br-ec-ae B.11.31 U ia64 4072183552 unlimited-user license
附件：resotre脚本 restore.txt (2.4 KB, 下载次数: 827)

2012-5-26 16:39 上传

点击文件名下载附件

ShineCQY

重新运行出错说没有权限，因为要覆盖的文件正在使用。现在我困惑的是RMAN-10038这个错误，为什么会异常终止？是10.2.0.2的
BUG吗？

Maclean Liu(刘相兵

ORA-19504: failed to create file "/oradata/BWP/sr3.data1"
ORA-27086: unable to lock file - already in use
HPUX-ia64 Error: 13: Permission denied

日志给出的信息已经很足够说明是权限问题了。

ShineCQY

权限问题：
$ ls -l /oradata
total 422
drwxrwxr-x   5 orabwp     dba           2048 May 26 17:07 BWP
$ pwd
/oradata/BWP
$ ls -l
total 41551344
drwxr-xr-x   2 orabwp     dba             96 May 26 14:30 cntrlA
drwxr-xr-x   2 orabwp     dba             96 May 26 14:30 cntrlB
drwxr-xr-x   2 orabwp     dba             96 May 26 14:30 cntrlC
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data1
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data10
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data11
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data12
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data13
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data14
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data2
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data3
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data4
-rw-r-----   1 orabwp     dba        10737426432 May 26 17:10 sr3.data5
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data6
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data7
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data8
-rw-r-----   1 orabwp     dba        10485768192 May 26 17:10 sr3.data9
-rwxr-xr-x   1 orabwp     dba        10485768192 May 26 15:22 sr3700.data6
-rwxr-xr-x   1 orabwp     dba        10485768192 May 26 15:00 undo.data1
alert日志 和报的错误一样

xifenfei

ORA-19504: failed to create file "/oradata/BWP/sr3.data1"
ORA-27086: unable to lock file - already in use
HPUX-ia64 Error: 13: Permission denied

检查/oradata/BWP 目录是否有权限