RMAN备份日志（分页）

　　RMAN备份的日志

Recovery Manager: Release 10.2.0.1.0 - Production on Tue May 12 02:01:37 2009

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

connected to target database: DQOMS (DBID=4131026225)

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE FILESPERSET 10
5> FORMAT 'incr_%T_%s_%p' DATABASE;
6> sql 'alter system archive log current';
7> BACKUP FILESPERSET 10 MAXSETSIZE 10G
8> FORMAT 'arch_%T_%s_%p'
9> SKIP INACCESSIBLE
10> ARCHIVELOG ALL DELETE INPUT;
11> release channel t1;
12> release channel t2;
13> }
14>
15>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=531 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

allocated channel: t2
channel t2: sid=520 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0

Starting backup at 12-MAY-09
channel t1: starting incremental level 1 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00007 name=/oracle/oms/oradata/log/Log_Norm_data000.dbf
input datafile fno=00009 name=/oracle/oms/oradata/drill/Drill_Norm_data000.dbf
input datafile fno=00015 name=/oracle/oms/oradata/gpe/GPE_NORM_data000.dbf
input datafile fno=00014 name=/oracle/oms/oradata/bbs/BBS_data000.dbf
input datafile fno=00004 name=/oracle/oms/oradata/sysdata/users01.dbf
input datafile fno=00022 name=/oracle/oms/oradata/temp/perfstat.dbf
input datafile fno=00001 name=/oracle/oms/oradata/sysdata/system01.dbf
input datafile fno=00002 name=/oracle/oms/oradata/undo/undotbs01.dbf
channel t1: starting piece 1 at 12-MAY-09
channel t2: starting incremental level 1 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00008 name=/oracle/oms/oradata/mlog/Mlog_Norm_data000.dbf
input datafile fno=00010 name=/oracle/oms/oradata/dh/DH_Norm_data000.dbf
input datafile fno=00006 name=/oracle/oms/oradata/pub/Pub_Norm_data000.dbf
input datafile fno=00011 name=/oracle/oms/oradata/wps/WPS_data000.dbf
input datafile fno=00012 name=/oracle/oms/oradata/jbpm/Jbpm_data000.dbf
input datafile fno=00013 name=/oracle/oms/oradata/srvreg/SrvReg_data000.dbf
input datafile fno=00005 name=/oracle/oms/oradata/sysdata/RMAN_data000.dbf
input datafile fno=00003 name=/oracle/oms/oradata/sysdata/sysaux01.dbf
channel t2: starting piece 1 at 12-MAY-09
RMAN-03009: failure of backup command on t1 channel at 05/12/2009 02:03:39
ORA-19502: write error on file "incr_20090512_8366_1", blockno 202753 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
channel t1 disabled, job failed on it will be run on another channel
channel t2: finished piece 1 at 12-MAY-09
piece handle=incr_20090512_8367_1 tag=TAG20090512T020143 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:07:54
channel t2: starting incremental level 1 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00007 name=/oracle/oms/oradata/log/Log_Norm_data000.dbf
input datafile fno=00009 name=/oracle/oms/oradata/drill/Drill_Norm_data000.dbf
input datafile fno=00015 name=/oracle/oms/oradata/gpe/GPE_NORM_data000.dbf
input datafile fno=00014 name=/oracle/oms/oradata/bbs/BBS_data000.dbf
input datafile fno=00004 name=/oracle/oms/oradata/sysdata/users01.dbf
input datafile fno=00022 name=/oracle/oms/oradata/temp/perfstat.dbf
input datafile fno=00001 name=/oracle/oms/oradata/sysdata/system01.dbf
input datafile fno=00002 name=/oracle/oms/oradata/undo/undotbs01.dbf
channel t2: starting piece 1 at 12-MAY-09
channel t2: finished piece 1 at 12-MAY-09
piece handle=incr_20090512_8368_1 tag=TAG20090512T020143 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:05:55
channel t2: starting incremental level 1 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00017 name=/oracle/oms/oradata/log/Log_Lob_data000.dbf
input datafile fno=00019 name=/oracle/oms/oradata/drill/Drill_Lob_data000.dbf
input datafile fno=00020 name=/oracle/oms/oradata/dh/DH_Lob_data000.dbf
channel t2: starting piece 1 at 12-MAY-09
channel t2: finished piece 1 at 12-MAY-09
piece handle=incr_20090512_8369_1 tag=TAG20090512T020143 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:05:55
channel t2: starting incremental level 1 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00016 name=/oracle/oms/oradata/gpe/Gpe_Lob_data000.dbf
input datafile fno=00018 name=/oracle/oms/oradata/mlog/Mlog_Lob_data000.dbf
input datafile fno=00021 name=/oracle/oms/oradata/pub/Pub_Lob_data000.dbf
channel t2: starting piece 1 at 12-MAY-09
channel t2: finished piece 1 at 12-MAY-09
piece handle=incr_20090512_8370_1 tag=TAG20090512T020143 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 00:05:36
Finished backup at 12-MAY-09

　　检查带库后，发现带库有一个驱动已经不能正常使用了。