免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2321 | 回复: 3
打印 上一主题 下一主题

[Veritas NBU] 用NBU恢复ORACLE数据库时出错,请高手指点! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2005-04-04 22:51 |只看该作者 |倒序浏览
Recovery Manager: Release 9.2.0.3.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

2>;
3>; # -----------------------------------------------------------------
4>; # RMAN command section
5>; # -----------------------------------------------------------------
6>;
7>; RUN {
8>;
9>; ALLOCATE CHANNEL ch00
10>;     TYPE 'SBT_TAPE';
11>; SEND 'NB_ORA_CLIENT=myTEST';
12>;
13>; RESTORE
14>;     TABLESPACE
15>;         'POD',
16>;         'POX'
17>;     UNTIL TIME "TO_DATE('03-22-2005:04:22:22', 'MM-DD-YYYY:HH24:MI:SS')";
18>;
19>; RECOVER
20>;     TABLESPACE
21>;         'POD',
22>;         'POX';
23>;
24>; RELEASE CHANNEL ch00;
25>; }
26>;
using target database controlfile instead of recovery catalog

allocated channel: ch00
channel ch00: sid=16 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)

sent command to channel: ch00

Starting restore at 31-MAR-05

channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00037 to /oradata/prod/proddata/pod01.dbf
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/31/2005 00:28:34
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   sbtclose2: Failed to process backup file.
ORA-19573: cannot obtain exclusive enqueue for datafile 37

Recovery Manager complete.

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Mar 31 00:28:35 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; Connected.
SQL>; alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance


SQL>; Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
以上内容为日志,不知道是什么错误引志的,请高手指点,多谢了!

论坛徽章:
0
2 [报告]
发表于 2005-04-05 08:46 |只看该作者

用NBU恢复ORACLE数据库时出错,请高手指点!

自己顶一下!

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
3 [报告]
发表于 2005-04-05 13:36 |只看该作者

用NBU恢复ORACLE数据库时出错,请高手指点!

1. shutdown immediate
2. startup mount
3. restore ORACLE via NBU
4. alter database open resetlogs

论坛徽章:
1
荣誉版主
日期:2011-11-23 16:44:17
4 [报告]
发表于 2005-04-06 00:18 |只看该作者

用NBU恢复ORACLE数据库时出错,请高手指点!

这脚本对吗?

恢复表空间的话,表空间offline就可以了吧
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP