- 最后登录
- 2015-3-26
- 在线时间
- 148 小时
- 威望
- 84
- 金钱
- 1061
- 注册时间
- 2011-11-26
- 阅读权限
- 50
- 帖子
- 128
- 精华
- 0
- 积分
- 84
- UID
- 96
|
1#
发表于 2012-5-26 16:39:12
|
查看: 7780 |
回复: 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)
|
|