- 论坛徽章:
- 0
|
oracle数据库备份报错。 server: windows平台, client: IBM p650。 备份软件: veritas nbu 5.0 数据库: oracle 8.16
1。 nbu系统报错代码为25。
2。 当前的备份策略为增量备份,schdule的设置为按月设置,但是只有25号以后的几个增量出这种问题,全备和其他没出国这种问题,开始的时候以为是二十几号的计费周期的缘故,后移计费周期到每月一号,但是还是出这问题。
3。 备份oracle的增量,前一两个job可以备份, 后来出错。 rman 输入日志如下:
RMAN-08008: channel ch00: starting incremental level 1 datafile backupset
RMAN-08502: set_count=8897 set_stamp=564797524 creation_time=28-JUL-05
RMAN-08010: channel ch00: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=/dev/rbillapp_03
RMAN-08522: input datafile fno=00017 name=/dev/rapp1_29
RMAN-08522: input datafile fno=00073 name=/dev/rbillapp_39
RMAN-08522: input datafile fno=00108 name=/dev/rbillapp_79
RMAN-08522: input datafile fno=00046 name=/dev/rapp1_23
RMAN> RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch01
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="bk_8896_1_564797179", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to open for backup.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN>
RMAN-08031: released channel: ch00
RMAN-08031: released channel: ch01
Recovery Manager complete.
Script /usr/openv/scripts/bk.sh
==== ended in error on Thu Jul 28 00:45:51 BEIDT 2005 ====
4。 检查ORA-27028的报错,有如下解释:
ORA-27028 skgfqcre: sbtbackup returned error
Cause: SBTBACKUP returned an error. This happens when creating a backup file during a backup operation.
Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the
cause of the error. This error usually requires contacting the media management vendor.
ORA-19624:operation failed, retry possibleCause:A backup, restore or image copy operation failed with an I/O error. If the source of the I/O error can be corrected, then the operation may be retried.Action:This message is used by Recovery Manager to decide whether or not to retry the operation.
5。 请现场工程师发bptm的日志。 并检查server和client的时间差。
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/2267/showart_38025.html |
|