houzi105
作者houzi1052012-04-28 10:12
系统工程师, @@@

rman channel failover

字数 2655阅读 5920评论 0赞 0

channel t3: starting piece 1 at 27-APR-12
RMAN-03009: failure of backup command on t3 channel at 04/27/2012 21:17:21
ORA-19502: write error on file "aon9gdnc_1_1", blockno 851545089 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1315W (RC15)   Unexpected retry request. The server found an error while writing the data.
channel t3 disabled, job failed on it will be run on another channel
channel t1: finished piece 1 at 28-APR-12
piece handle=amn9gdnc_1_1 tag=TAG20120427T183102 comment=API Version 2.0,MMS Version 5.5.2.1
channel t1: backup set complete, elapsed time: 05:53:43
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset

 

######################################################

oracle官方相关的解释:

A BACKUP command is decomposed into multiple independent backup steps by
RMAN. Each independent step can be executed on any channel allocated for the type
of device used in the command. If you have multiple channels allocated, and one
channel fails or encounters a problem during a backup step, then RMAN attempts to
complete the work on another channel. Typically, such retriable errors can occur when
a media manager encounters problems with one of several tape drives, or when an
instance fails in a RAC environment.
RMAN reports a message in V$RMAN_OUTPUT and in the output to the interactive
session or log file when it encounters such problems, as in the following example (refer
to bold text):
channel ORA_SBT_TAPE_1: backup set failed, re-triable on other channel
ORA-19506: failed to create sequential file, name="/bkup/63d3c3og_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text: failed to open
file /bkup/63d3c3og_1_1 for backup, errno = 2
channel ORA_SBT_TAPE_2: finished piece 1 at 06-SEP-01 piece handle=5ld3blun_1_1
comment=API Version 2.0,MMS Version 3.2.0.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:04
retrying ORA_SBT_TAPE_1 failed backup step on ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: starting full datafile backupset
channel ORA_SBT_TAPE_2: specifying datafile(s) in backupset input datafile
fno=00004 name=/oracle/dbs/tbs_12.f input datafile
fno=00017 name=/oracle/dbs/tbs_14.f
channel ORA_SBT_TAPE_2: starting piece 1 at 06-SEP-01 piece handle=5ld3buds_1_1
comment=API Version 2.0,MMS Version 3.2.0.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:06
Note that if RMAN is executing a script, then the next command in the script will not
be executed if there were any errors in the previous command.

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广