Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

84

积分

1

好友

27

主题
1#
发表于 2012-5-26 16:39:12 | 查看: 7781| 回复: 4
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, 下载次数: 873)
2#
发表于 2012-5-26 16:46:31
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 目录是否有权限

回复 只看该作者 道具 举报

3#
发表于 2012-5-26 17:01:39
权限问题:
$ 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日志 和报的错误一样

回复 只看该作者 道具 举报

4#
发表于 2012-5-26 22:59:13
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

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

回复 只看该作者 道具 举报

5#
发表于 2012-5-27 13:05:29
重新运行出错说没有权限,因为要覆盖的文件正在使用。现在我困惑的是RMAN-10038这个错误,为什么会异常终止?是10.2.0.2的
BUG吗?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 00:35 , Processed in 0.053196 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569