- 論壇徽章:
- 0
|
oracle數(shù)據(jù)庫備份報錯。 server: windows平臺, client: IBM p650。 備份軟件: veritas nbu 5.0 數(shù)據(jù)庫: oracle 8.16
1。 nbu系統(tǒng)報錯代碼為25。
2。 當(dāng)前的備份策略為增量備份,schdule的設(shè)置為按月設(shè)置,但是只有25號以后的幾個增量出這種問題,全備和其他沒出國這種問題,開始的時候以為是二十幾號的計費(fèi)周期的緣故,后移計費(fèi)周期到每月一號,但是還是出這問題。
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。 請現(xiàn)場工程師發(fā)bptm的日志。 并檢查server和client的時間差。
本文來自ChinaUnix博客,如果查看原文請點(diǎn):http://blog.chinaunix.net/u/2267/showart_38025.html |
|