论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-04-17 10:39 |只看该作者 |倒序浏览

环境为: NBU Server : NBU4.5 , AIX5.2\r\n NBU Client : NBU4.5 ,AIX 5.2 ,Oracle 9.2\r\n\r\n我建了两个RMAN备份的Policy，一个Policy做每周的Full database backup;一个Policy做每天的Archive log backup。（Scripts用NBU自带的sample修改的）\r\n这两个Policy的备份都正常，返回值都为0。\r\n但是在恢复是出现错误；\r\n我的恢复一是用RMAN命令：\r\nRMAN>;run{\r\n2>; allocate channel ch00 type disk;\r\n3>; restore\r\n4>; database;\r\n5>; recover\r\n6>; database;\r\n7>; release channel ch00;\r\n8>; }\r\n另是用NBU Client的jbpSA，但是都返回错误。\r\n\r\n以下是用jbpSA执行时的log：\r\nRecovery Manager: Release 9.2.0.4.0 - 64bit Production\r\n\r\nCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.\r\n\r\n2>; \r\n3>; # -----------------------------------------------------------------\r\n4>; # RMAN command section\r\n5>; # -----------------------------------------------------------------\r\n6>; \r\n7>; RUN {\r\n8>; \r\n9>; ALLOCATE CHANNEL ch00 \r\n10>; TYPE \'SBT_TAPE\';\r\n11>; SEND \'NB_ORA_CLIENT=p670a_svr\';\r\n12>; \r\n13>; RESTORE\r\n14>; DATABASE\r\n15>; CHECK READONLY;\r\n16>; \r\n17>; RECOVER\r\n18>; DATABASE;\r\n19>; \r\n20>; RELEASE CHANNEL ch00;\r\n21>; }\r\n22>; \r\nusing target database controlfile instead of recovery catalog\r\n\r\nallocated channel: ch00\r\nchannel ch00: sid=13 devtype=SBT_TAPE\r\nchannel ch00: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)\r\n\r\nsent command to channel: ch00\r\n\r\nStarting restore at 16-APR-04\r\n\r\nchannel ch00: starting datafile backupset restore\r\nchannel ch00: specifying datafile(s) to restore from backup set\r\nrestoring datafile 00001 to /oradata/hzsgs/system01.dbf\r\nrestoring datafile 00010 to /oradata/hzsgs/GSJ.dbf\r\nrestoring datafile 00016 to /oradata/hzsgs/expand/GONGSU.dbf\r\nreleased channel: ch00\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of restore command at 04/16/2004 15:43:46\r\nORA-19507: failed to retrieve sequential file, handle=\"bk_47_1_523634981\", parms=\"\"\r\nORA-27029: skgfrtrv: sbtrestore returned error\r\nORA-19511: Error received from media manager layer, error text:\r\n sbtrestore: Failed to open for restore.\r\n\r\nRecovery Manager complete.\r\n\r\n\r\n那位熟悉NBU的大虾一起分析分析，Thank you

itpoper

稍有积蓄

论坛徽章:: 0

2楼 [报告]

发表于 2004-04-17 10:40 |只看该作者

Netbackup For Oracle RMAN恢复出错

刚才的RMAN命令写错了，为\r\nRMAN>;run{ \r\n2>; allocate channel ch00 type \'sbt_tape\'; \r\n3>; restore \r\n4>; database; \r\n5>; recover \r\n6>; database; \r\n7>; release channel ch00;