免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2349 | 回复: 5

[Veritas NBU] 无法将oracle database恢复到另一台伺服器上 [复制链接]

论坛徽章:
0
发表于 2014-01-29 11:07 |显示全部楼层
小弟在幫客戶做測試將Oracle RAC上的DB恢復到一台VM的oracle DB上....
oracle RAC上的SPFILE已经成功汇入到VM的oracle DB上..但每次尝试跑恢复的工作时
下面是用的命令和失败报错:

RMAN> set dbid=1753225269

executing command: SET DBID

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE 'SBT_TAPE';
restore controlfile from autobackup MAXSEQ 5 MAXDAYS 9;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on T1 channel at 01/28/2014 17:32:20
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE DISK;
restore controlfile from autobackup MAXSEQ 5 MAXDAYS 9;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: T1
channel T1: sid=871 devtype=DISK

Starting restore at 28-JAN-14

channel T1: looking for autobackup on day: 20140128
channel T1: looking for autobackup on day: 20140127
channel T1: looking for autobackup on day: 20140126
channel T1: looking for autobackup on day: 20140125
channel T1: looking for autobackup on day: 20140124
channel T1: looking for autobackup on day: 20140123
channel T1: looking for autobackup on day: 20140122
channel T1: looking for autobackup on day: 20140121
channel T1: looking for autobackup on day: 20140120
channel T1: no autobackup in 9 days found
released channel: T1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/28/2014 17:32:37
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE DISK;
restore controlfile;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: T1
channel T1: sid=871 devtype=DISK

Starting restore at 28-JAN-14

released channel: T1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/28/2014 17:33:02
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

RMAN>

论坛徽章:
0
发表于 2014-01-29 16:10 |显示全部楼层
没有做oracle_link。。。。。

论坛徽章:
0
发表于 2014-01-29 16:55 |显示全部楼层
cigar_love 发表于 2014-01-29 16:10
没有做oracle_link。。。。。

謝謝,完全正確....之後做了一次oracle_link,再跑rman命令時,RMAN還是報錯...不過很奇怪的是,MBU Activity Monitor上面看到restore是成功的

RMAN> run {
set controlfile autobackup format for device type 'SBT_TAPE' to '%F';
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=vasbackup, NB_ORA_CLIENT=mpdb-b-vasclient';
restore controlfile from autobackup;
}

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: CH00
channel CH00: sid=873 devtype=SBT_TAPE
channel CH00: Veritas NetBackup for Oracle - Release 7.5 (2012020801)

sent command to channel: CH00

Starting restore at 29-JAN-14

channel CH00: looking for autobackup on day: 20140129
channel CH00: autobackup found: c-1753225269-20140129-02
released channel: CH00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/29/2014 16:01:02
ORA-19870: error reading backup piece c-1753225269-20140129-02
ORA-19608: c-1753225269-20140129-02 is not a backup piece

:::::::::::::::::::::::::::::::下面是NBU的job details::::::::::::::::::::::::::::::::::::::::::::::::
01/29/2014 16:02:33 - begin Restore
01/29/2014 16:02:33 - number of images required: 1
01/29/2014 16:02:33 - media needed: W4O1L4
01/29/2014 16:02:34 - restoring from image mpdb-b-vasclient_1390932918
01/29/2014 16:02:35 - Info bpbrm (pid=30794) itcdbtest is the host to restore to
01/29/2014 16:02:35 - Info bpbrm (pid=30794) telling media manager to start restore on client
01/29/2014 16:02:35 - Info bpbrm (pid=30794) spawning a brm child process
01/29/2014 16:02:35 - Info bpbrm (pid=30794) child pid: 30805
01/29/2014 16:02:35 - Info bpbrm (pid=30794) listening for client connection
01/29/2014 16:02:36 - Info bptm (pid=30796) Waiting for mount of media id W4O1L4 (copy 1) on server vasbackup.
01/29/2014 16:02:36 - started process bptm (pid=30796)
01/29/2014 16:02:36 - mounting W4O1L4
01/29/2014 16:02:36 - requesting resource W4O1L4
01/29/2014 16:02:36 - granted resource  W4O1L4
01/29/2014 16:02:36 - granted resource  HP.ULTRIUM4-SCSI.000
01/29/2014 16:02:37 - Info bptm (pid=30796) INF - Waiting for mount of media id W4O1L4 on server vasbackup for reading.
01/29/2014 16:02:37 - Info bpbrm (pid=30794) accepted connection from client
01/29/2014 16:02:37 - Info tar (pid=5687) Restore started.
01/29/2014 16:03:37 - mounted W4O1L4; mount time: 0:01:01
01/29/2014 16:03:37 - Info bptm (pid=30796) W4O1L4
01/29/2014 16:03:37 - Info bptm (pid=30796) INF - Waiting for positioning of media id W4O1L4 on server vasbackup for reading.
01/29/2014 16:03:37 - positioning W4O1L4 to file 146
01/29/2014 16:06:32 - positioned W4O1L4; position time: 0:02:55
01/29/2014 16:06:32 - begin reading
01/29/2014 16:06:34 - Info tar (pid=5687) done. status: 0: the requested operation was successfully completed
01/29/2014 16:06:34 - Info bpbrm (pid=30794) sending message to media manager: STOP RESTORE mpdb-b-vasclient_1390932918 EXIT=0
01/29/2014 16:06:34 - end reading; read time: 0:00:02
01/29/2014 16:06:35 - restored from image mpdb-b-vasclient_1390932918; restore time: 0:04:01
01/29/2014 16:06:35 - end Restore; elapsed time 0:04:02
the requested operation was successfully completed  (0)

论坛徽章:
2
2015年迎新春徽章
日期:2015-03-03 17:33:52数据库技术版块每日发帖之星
日期:2015-09-21 06:20:00
发表于 2014-02-07 14:49 |显示全部楼层
不要用“from autobackup”,直接写nbu备份的piece名。

论坛徽章:
0
发表于 2014-02-08 23:45 |显示全部楼层
w3wu 发表于 2014-02-07 14:49
不要用“from autobackup”,直接写nbu备份的piece名。


试过了....一样的报错
前两天在oracle support上开了服务请求, 服务人员说因为我RAC的环境是SPARC,所以
前兩天在oracle support上開了服務請求, 服務人員說因為我RAC的環境是SPARC,所以另一台用来测试的机械也要SPARC的
另外DB的版本也最好是一样....RAC是oracle 10.2.0.4, 测试的机械是10.2.0.1

论坛徽章:
0
发表于 2014-04-25 15:12 |显示全部楼层
LZ,controlfile autobackup只是针对磁盘,NB_ORA_CLIENT是RAC主机的名称;
另外,使用bplist可以更好的恢复出控制文件。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

PostgreSQL中国大会,早鸟票抢购!

PostgreSQL中国大会,早鸟票抢购!
2019年11月29~11月30日,由 PostgreSQL中文社区与ITPUB联合主办的第九届《PostgreSQL 中国技术大会》将在北京隆重召开。PostgreSQL 作为功能最强的的开源关系型数据库之一,得到了越来越多企业的推广和运用,也越来越受到广大技术爱好者的欢迎和重视。这将是 PostgreSQL 的又一次交流盛会。




----------------------------------------

点击报名>>
  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP