rman多通道的并发
下面是磁带库上的备份日志：
RMAN> CONNECT TARGET *
2> HOST 'exit';
3> run {
4> allocate channel 'dev_0' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
7> allocate channel 'dev_1' type 'sbt_tape'parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
10> allocate channel 'dev_2' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
13> allocate channel 'dev_3' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
16> send device type 'sbt_tape' 'OB2BARHOSTNAME=gspndb_vip';
17> send channel 'dev_0' 'OB2BARTYPE=Oracle8';
18> send channel 'dev_0' 'OB2APPNAME=PROD';
19> send channel 'dev_0' 'OB2BARLIST=DB_PROD_FULL_SCP';
20> send channel 'dev_1' 'OB2BARTYPE=Oracle8';
21> send channel 'dev_1' 'OB2APPNAME=PROD';
22> send channel 'dev_1' 'OB2BARLIST=DB_PROD_FULL_SCP';
23> send channel 'dev_2' 'OB2BARTYPE=Oracle8';
24> send channel 'dev_2' 'OB2APPNAME=PROD';
25> send channel 'dev_2' 'OB2BARLIST=DB_PROD_FULL_SCP';
26> send channel 'dev_3' 'OB2BARTYPE=Oracle8';
27> send channel 'dev_3' 'OB2APPNAME=PROD';
28> send channel 'dev_3' 'OB2BARLIST=DB_PROD_FULL_SCP';
29> backup incremental level 0 format 'DB_PROD_FULL_SCP<PROD_%s:%t:%p>.dbf' database;
32> sql 'alter system archive log current';
35> backup format 'DB_PROD_FULL_SCP<PROD_%s:%t:%p>.dbf' archivelog all;
38> backup format 'DB_PROD_FULL_SCP<PROD_%s:%t:%p>.dbf' current controlfile;
41> }
42> EXIT
RMAN-06005: connected to target database: PROD (DBID=4144310150)
RMAN-06009: using target database control file instead of recovery catalog
RMAN-03090: Starting backup at 12-DEC-24
RMAN-08048: channel dev_0: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_0: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00007 name=/oracle/PROD/data4/biz03.dbf
RMAN-08522: input datafile file number=00013 name=/oracle/PROD/data5/biz08.dbf
RMAN-08522: input datafile file number=00016 name=/oracle/PROD/data6/biz11.dbf
RMAN-08522: input datafile file number=00009 name=/oracle/PROD/data3/biz05.dbf
RMAN-08522: input datafile file number=00002 name=/oracle/PROD/data1/sysaux01.dbf
RMAN-08038: channel dev_0: starting piece 1 at 12-DEC-24
RMAN-08048: channel dev_1: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00006 name=/oracle/PROD/data4/biz02.dbf
RMAN-08522: input datafile file number=00012 name=/oracle/PROD/data5/biz07.dbf
RMAN-08522: input datafile file number=00015 name=/oracle/PROD/data6/biz10.dbf
RMAN-08522: input datafile file number=00017 name=/oracle/PROD/data7/biz12.dbf
RMAN-08038: channel dev_1: starting piece 1 at 12-DEC-24
RMAN-08048: channel dev_2: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_2: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00005 name=/oracle/PROD/data4/biz01.dbf
RMAN-08522: input datafile file number=00011 name=/oracle/PROD/data5/biz06.dbf
RMAN-08522: input datafile file number=00014 name=/oracle/PROD/data6/biz09.dbf
RMAN-08522: input datafile file number=00008 name=/oracle/PROD/data3/biz04.dbf
RMAN-08522: input datafile file number=00010 name=/oracle/PROD/data3/portal.dbf
RMAN-08038: channel dev_2: starting piece 1 at 12-DEC-24
RMAN-08048: channel dev_3: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_3: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00003 name=/oracle/PROD/data2/undotbs01.dbf
RMAN-08522: input datafile file number=00001 name=/oracle/PROD/data1/system01.dbf
RMAN-08522: input datafile file number=00004 name=/oracle/PROD/data1/users01.dbf
RMAN-08038: channel dev_3: starting piece 1 at 12-DEC-24
RMAN-08044: channel dev_3: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96452:1187544912:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_3: backup set complete, elapsed time: 00:06:15
RMAN-08048: channel dev_3: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_3: specifying datafile(s) in backup set
RMAN-08011: including current control file in backup set
RMAN-08038: channel dev_3: starting piece 1 at 12-DEC-24
RMAN-08044: channel dev_3: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96453:1187545287:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_3: backup set complete, elapsed time: 00:00:07
RMAN-08048: channel dev_3: starting incremental level 0 datafile backup set
RMAN-08010: channel dev_3: specifying datafile(s) in backup set
RMAN-08113: including current SPFILE in backup set
RMAN-08038: channel dev_3: starting piece 1 at 12-DEC-24
RMAN-08044: channel dev_3: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96454:1187545295:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_3: backup set complete, elapsed time: 00:00:03
RMAN-08044: channel dev_1: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96450:1187544912:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_1: backup set complete, elapsed time: 00:32:28
RMAN-08044: channel dev_2: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96451:1187544912:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_2: backup set complete, elapsed time: 00:32:48
RMAN-08044: channel dev_0: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96449:1187544912:1>.dbf tag=TAG20241212T173512 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_0: backup set complete, elapsed time: 00:35:48
RMAN-03033: current log archived
RMAN-06502: skipping archived logs of thread 1 from sequence 121 to 125; already backed up
RMAN-08009: channel dev_0: starting archived log backup set
RMAN-08014: channel dev_0: specifying archived log(s) in backup set
RMAN-08504: input archived log thread=1 sequence=126 RECID=30428 STAMP=1187521750
RMAN-08504: input archived log thread=1 sequence=127 RECID=30429 STAMP=1187521917
RMAN-08504: input archived log thread=1 sequence=128 RECID=30430 STAMP=1187521919
RMAN-08038: channel dev_0: starting piece 1 at 12-DEC-24
RMAN-08009: channel dev_1: starting archived log backup set
RMAN-08014: channel dev_1: specifying archived log(s) in backup set
RMAN-08504: input archived log thread=1 sequence=130 RECID=30432 STAMP=1187528409
RMAN-08038: channel dev_1: starting piece 1 at 12-DEC-24
RMAN-08009: channel dev_2: starting archived log backup set
RMAN-08014: channel dev_2: specifying archived log(s) in backup set
RMAN-08504: input archived log thread=1 sequence=131 RECID=30433 STAMP=1187547061
RMAN-08504: input archived log thread=1 sequence=132 RECID=30434 STAMP=1187547061
RMAN-08504: input archived log thread=1 sequence=133 RECID=30435 STAMP=1187547061
RMAN-08038: channel dev_2: starting piece 1 at 12-DEC-24
RMAN-08009: channel dev_3: starting archived log backup set
RMAN-08014: channel dev_3: specifying archived log(s) in backup set
RMAN-08504: input archived log thread=1 sequence=134 RECID=30436 STAMP=1187547061
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96458:1187547061:1>.dbf tag=TAG20241212T181101 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_3: backup set complete, elapsed time: 00:00:07
RMAN-08044: channel dev_2: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96457:1187547061:1>.dbf tag=TAG20241212T181101 comment=API Version 2.0,MMS Version 65.10.60.154
RMAN-08540: channel dev_2: backup set complete, elapsed time: 00:00:15
RMAN-08044: channel dev_1: finished piece 1 at 12-DEC-24
RMAN-08530: piece handle=DB_PROD_FULL_SCP<PROD_96456:1187547061:1>.dbf tag=TAG20241212T181101 comment=API Version 2.0,MMS Version 65.10.60.154
| channel | num/seq | file | tag |
|---|---|---|---|
| 0 | 2，7，9，13，16 | 96449 | 173512 |
| 1 | 6，12，15，17 | 96450 | 173512 |
| 2 | 5，8，10，11，14 | 96451 | 173512 |
| 3 | 1，3，4（最少） | 96452 | 173512 |
| 3 | controlfile | 96453 | 173512 |
| 3 | spfile | 96454 | 173512 |
| 0 | 126~128 | 96455 | 181101 |
| 1 | 130(少129) | 96456 | 181101 |
| 2 | 131~133 | 96457 | 181101 |
| 3 | 134 | 96458 | 181101 |
| 0 | controlfile | 96459 | 181136 |
每个通道都分配了多个文件。
