wanghepeng1986 发表于 2014-2-18 18:25:28

rman异地恢复数据库报错

原环境：AIX
              RAC 11.2.0.3 64bit
目标环境：linux 5.5
                 单实例 11.2.0.3 64bit

然后我把生产那边的控制文件备份拿到本地恢复，老是报下边这样错误，想咨询一下是那块出了问题。

$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Feb 18 18:16:43 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CRMDB1 (not mounted)

RMAN> set dbid=3920514275;

executing command: SET DBID

RMAN> restore controlfile from '/img/ncsnf0_TAG20140214T152339_0.679.839518565';

Starting restore at 18-FEB-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK

channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/18/2014 18:17:15
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Maclean Liu(刘相兵 发表于 2014-2-18 21:27:13

catalog backuppiece '/img/ncsnf0_TAG20140214T152339_0.679.839518565';

list backup of controlfile;

看下结果

clevernby 发表于 2014-2-19 10:38:32

本帖最后由 clevernby 于 2014-2-19 10:40 编辑

specified handle is not a valid copy or piece
endian有关

生生不息 发表于 2014-2-19 11:36:29

确认/img/ncsnf0_TAG20140214T152339_0.679.839518565是controlfile 的automatic备份，如果不是建议从源服务器的$ORACLE_HOME/dbs目录找到controlfile的automatic备份，然后从该自动备份集中恢复。

dba_sky 发表于 2014-2-27 17:11:28

/img/ncsnf0_TAG20140214T152339_0.679.839518565 这个备份片应该没有controlfile的备份。

请楼主确认。

wanghepeng1986 发表于 2014-3-4 20:11:28

dba_sky 发表于 2014-2-27 17:11 static/image/common/back.gif
/img/ncsnf0_TAG20140214T152339_0.679.839518565 这个备份片应该没有controlfile的备份。

请楼主确认。 ...

有controlfile的备份，后来问oracle，aix不能导入linux
页: [1]
查看完整版本: rman异地恢复数据库报错