免费注册 查看新帖 |

Chinaunix

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

[求助]rman备份出错 RMAN-03009 ORA-19505 ORA-27037 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-07-03 11:51 |只看该作者 |倒序浏览
OS:HP-UX 11.23     
ORACLE 10.2.0.3  做了RAC
用的HP DP备份软件

出错信息:

[Normal] From: BSM@hp-385-07 "db-full"  Time: 2009-7-3 11:29:14
        OB2BAR application on "databas1_vip" successfully started.

[Normal] From: ob2rman@databas1 "db"  Time: 07/03/09 11:29:26
        Starting backup of target database.

        Net service name: db2.
        Instance status: OPEN.
        Instance name: db2.
        Database DBID = 2703117387.
        Database control file type: CURRENT.
        Database log mode: ARCHIVELOG.


        Net service name: db1.
        Instance status: OPEN.
        Instance name: db1.
        Database DBID = 2703117387.
        Database control file type: CURRENT.
        Database log mode: ARCHIVELOG.


[Normal] From: ob2rman@databas1 "db"  Time: 07/03/09 11:29:38
        Starting Oracle Recovery Manager.


Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jul 3 11:29:38 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> CONNECT TARGET *
2> CONNECT CATALOG *
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5>  parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=db,OB2BARLIST=db-full,OB2BARHOSTNAME=databas1_vip)';
6> backup incremental level 0
7>  format 'db-full<db_%s:%t:%p>.dbf'
8>  database;
9> backup
10>  format 'db-full<db_%s:%t:%p>.dbf'
11>  current controlfile;
12> }
13> EXIT
connected to target database: db (DBID=2703117387)

connected to recovery catalog database

allocated channel: dev_0
channel dev_0: sid=1064 instance=db1 devtype=SBT_TAPE
channel dev_0: Data Protector A.06.00/331

Starting backup at 03-JUL-09
channel dev_0: starting incremental level 0 datafile backupset
channel dev_0: specifying datafile(s) in backupset
input datafile fno=00006 name=/dev/oraclevg/rgdcx01
input datafile fno=00007 name=/dev/oraclevg/rgpssource01
input datafile fno=00008 name=/dev/oraclevg/rgdcx02
input datafile fno=00009 name=/dev/oraclevg/rgpssource02
input datafile fno=00010 name=/dev/oraclevg/rgdcx03
input datafile fno=00011 name=/dev/oraclevg/rsde01
input datafile fno=00012 name=/dev/oraclevg/rgpssource03
input datafile fno=00013 name=/dev/oraclevg/rgdcx04
input datafile fno=00014 name=/dev/oraclevg/rgdcx05
input datafile fno=00015 name=/dev/oraclevg/rgpssource04
input datafile fno=00016 name=/dev/oraclevg/rsde02
input datafile fno=00017 name=/dev/oraclevg/rgpssource05
input datafile fno=00018 name=/dev/oraclevg/rsde03
input datafile fno=00019 name=/dev/oraclevg/rsde04
input datafile fno=00020 name=/dev/oraclevg/rsde05
input datafile fno=00002 name=/dev/oraclevg/rundo1
input datafile fno=00004 name=/dev/oraclevg/rundo2
input datafile fno=00001 name=/dev/oraclevg/rsystem
input datafile fno=00003 name=/dev/oraclevg/rsysaux
input datafile fno=00005 name=/dev/oraclevg/ruser01
input datafile fno=00021 name=/dev/oraclevg/TPM.dbf
input datafile fno=00022 name=/dev/oraclevg/rtpm02.dbf
channel dev_0: starting piece 1 at 03-JUL-09
[Normal] From: BMA@hp-385-07 "HP:Ultrium 3-SCSI_1_hp-385-07"  Time: 2009-7-3 11:29:41
        STARTING Media Agent "HP:Ultrium 3-SCSI_1_hp-385-07"

[Normal] From: BMA@hp-385-07 "HP:Ultrium 3-SCSI_1_hp-385-07"  Time: 2009-7-3 11:29:44
        By: UMA@hp-385-07@scsi4:0:2:1
        Loading medium from slot 24 to device scsi4:0:2:0C

[Normal] From: OB2BAR_Oracle8@databas1 "db"  Time: 2009-7-3 11:30:38
        Starting OB2BAR Backup: databas1_vip:db-full<db_608:691241386:1>.dbf "Oracle8"

[Normal] From: OB2BAR_Oracle8@databas1 "db"  Time: 2009-7-3 11:31:56
        Completed OB2BAR Backup: databas1_vip:db-full<db_608:691241386:1>.dbf "Oracle8"

released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 07/03/2009 11:32:01
ORA-19505: failed to identify file "/dev/oraclevg/rgdcx01"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 10: No child processes
Additional information: 17

Recovery Manager complete.
[Major] From: ob2rman@databas1 "db"  Time: 07/03/09 11:32:02
        The database reported error while performing requested operation.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 07/03/2009 11:32:01
ORA-19505: failed to identify file "/dev/oraclevg/rgdcx01"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 10: No child processes
Additional information: 17

Recovery Manager complete.

[Major] From: ob2rman@databas1 "db"  Time: 07/03/09 11:32:03
        Oracle Recovery Manager completed with errors.

[Major] From: ob2rman@databas1 "db"  Time: 07/03/09 11:32:04
        Backup of target database failed.

[Normal] From: BSM@hp-385-07 "db-full"  Time: 2009-7-3 11:32:29
        OB2BAR application on "databas1_vip" disconnected.

[Normal] From: BMA@hp-385-07 "HP:Ultrium 3-SCSI_1_hp-385-07"  Time: 2009-7-3 11:33:46
        scsi4:0:2:0C
        Medium header verification completed, 0 errors found

[Normal] From: BMA@hp-385-07 "HP:Ultrium 3-SCSI_1_hp-385-07"  Time: 2009-7-3 11:34:06
        By: UMA@hp-385-07@scsi4:0:2:1
        Unloading medium to slot 24 from device scsi4:0:2:0C

[Normal] From: BMA@hp-385-07 "HP:Ultrium 3-SCSI_1_hp-385-07"  Time: 2009-7-3 11:34:31
        COMPLETED Media Agent "HP:Ultrium 3-SCSI_1_hp-385-07"

[Normal] From: BSM@hp-385-07 "db-full"  Time: 2009-7-3 11:34:31

        Backup Statistics:
         
                Session Queuing Time (hours)      0.00        
                ----------------------------------------      
                Completed Disk Agents ........       1         
                Failed Disk Agents ...........       0         
                Aborted Disk Agents ..........       0         
                ----------------------------------------      
                Disk Agents Total  ...........       1         
                ========================================      
                Completed Media Agents .......       1         
                Failed Media Agents ..........       0         
                Aborted Media Agents .........       0         
                ----------------------------------------      
                Media Agents Total  ..........       1         
                ========================================      
                Mbytes Total .................    1 MB      
                Used Media Total .............       1         
                Disk Agent Errors Total ......       0   


============================================================================
                      Session completed with errors!
============================================================================

论坛徽章:
0
2 [报告]
发表于 2009-07-03 11:52 |只看该作者
那个文件是有的
$ ll /dev/oraclevg/rgdcx01
crw-rw----   1 oracle     oinstall    64 0x020017 Nov 27  2008 /dev/oraclevg/rgdcx01

论坛徽章:
2
丑牛
日期:2014-06-11 13:55:04ChinaUnix元老
日期:2015-02-06 15:16:14
3 [报告]
发表于 2009-07-03 14:35 |只看该作者
检查系统资源
HPUX不太熟,但这个错误应该是子进程创建失败,你可以问问懂的人
HPUX-ia64 Error: 10: No child processes

论坛徽章:
0
4 [报告]
发表于 2009-07-03 17:31 |只看该作者

回复 #3 山野村夫 的帖子

嗯,好的   谢谢
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP