Rman multisection backup Test 2, rmanmultisection

Rman multisection backup Test 2, rmanmultisection

Use section size in the two channels for backup.

[Oracle @ rhel63single ~] $ Rman target/Recovery Manager: Release 11.2.0.4.0-Production on Thu Feb 19 01:07:28 2015 Copyright (c) 1982,201 1, Oracle and/or its affiliates. all rights reserved. connected to target database: TEST (DBID = 2106028980) RMAN> RUN2> {3> allocate channel disk1 device type disk format'/u02/disk1/% U '; 4> allocate channel disk2 device type disk format'/u02/disk2/% U'; 5> backup section size 300 m datafile 1; 6 >}released channel: ORA_DISK_1allocated channel: disk1channel disk1: SID = 133 device type = DISKallocated channel: disk2channel disk2: SID = 70 device type = DISKStarting backup at 19-FEB-15channel disk1: starting full datafile backup setchannel disk1: specifying datafile (s) in backup setinput datafile file number = 00001 name =/u01/app/oracle/oradata/test/system01.dbf ----> system01.dbfbacking up block S 1 through 38400 ----------------------------------------------> note here channel disk1: starting piece 1 at 19-FEB-15channel disk2: starting full datafile backup setchannel disk2: specifying datafile (s) in backup setincluding current control file in backup set ---------------------------------------> control file backup channel disk2: starting piece 1 at 19-FEB-15channel disk2: finished piece 1 at 19-FEB-15piece Handle =/u02/disk2/0bpvkm86_1_1 tag = TAG20150219T024005 comment = NONE -----------> the backup of the control file is generated (as shown in the following list backup of controlfile ), however, it can only be determined based on the output log above. It cannot be determined that the backup of the control file is used. Channel disk2: backup set complete, elapsed time: 00: 00: 07 channel disk2: starting full datafile backup setchannel disk2: specifying datafile (s) in backup setinput datafile file number = 00001 name =/u01/app/oracle/oradata/test/system01.dbfbacking up blocks 38401 through 76800 blocks> note that the first sectionchannel disk2 is called here: starting piece 2 at 19-FEB-15channel disk1: finished piece 1 at 19-FEB-15piece handle =/u02/disk1/partition tag = partition comment = NONE -----------> the backuppiece of the first section is generated. channel disk1: backup set complete, elapsed time: 00: 00: 29 channel disk1: starting full datafile backup setchannel disk1: specifying datafile (s) in backup setinput datafile file number = 00001 name =/u01/app/oracle/oradata/test/system01.dbfbacking up blocks 76801 through 102400 blocks> note that the second sectionchannel disk1 is called here: starting piece 3 at 19-FEB-15channel disk2: finished piece 2 at 19-FEB-15piece handle =/u02/disk2/partition tag = partition comment = NONE -----------> the backuppiece of the second section is generated. channel disk2: backup set complete, elapsed time: 00: 00: 47 channel disk2: starting full datafile backup setchannel disk2: specifying datafile (s) in backup setincluding current SPFILE in backup setchannel disk2: starting piece 1 at 19-FEB-15channel disk1: finished piece 3 at 19-FEB-15piece handle =/u02/disk1/partition tag = partition comment = NONE -----------> the backuppiece of the third section is generated. channel disk1: backup set complete, elapsed time: 00: 00: 35 channel disk2: finished piece 1 at 19-FEB-15piece handle =/u02/disk2/0epvkmak_1_1 tag = partition comment = NONE -----------> spfile backup (as shown in the following list backup of spfile) channel disk2: backup set complete, elapsed time: 00: 00: 01 Finished backup at 19-FEB-15released channel: disk1released channel: disk2RMAN> list backup of spfile; list of Backup Sets ============================ BS Key Type LV Size Device Type Elapsed Time Completion Time ---------------------------------------------- --------------- 2 Full 9.36 m disk 00:00:04 19-FEB-15 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20150219T011148 Piece Name:/u02/09pvkh4o_1_1 SPFILE pinned ded: Modification time: 19-FEB-15 SPFILE db_unique_name: TESTBS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ------------ ---------------- ----------------- 5 Full 80.00 k disk 00:00:01 19-FEB-15 BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20150219T024005 Piece Name:/u02/disk2/0epvkmak_1_1 SPFILE encoded ded: Modification time: 19-FEB-15 SPFILE db_unique_name: TESTRMAN> list backup of controlfile; list of Backup Sets ============================ BS Key Type LV Size Device Type Elapsed Time Completion Time ---------------------------------------------- --------------- 2 Full 9.36 m disk 00:00:04 19-FEB-15 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20150219T011148 Piece Name:/u02/09pvkh4o_1_1 Control File pinned ded: Ckp SCN: 3198153 Ckp time: 19-FEB-15BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ---------------- ------------------- 3 Full 9.33 m disk 00:00:06 19-FEB-15 BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20150219T024005 Piece Name:/u02/disk2/0bpvkm86_1_1 Control File encoded ded: Ckp SCN: 3201429 Ckp time: 19-FEB-15RMAN> list backup of datafile 1; list of Backup Sets ============================ BS Key Type LV Size Device Type Elapsed Time Completion Time ---------------------------------------------- --------------- 1 Full 703.80 m disk 00:00:59 19-FEB-15 List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- ---------- --------- ---- 1 Full 3198130 19-FEB-15/u01/app/oracle/ oradata/test/system01.dbf Backup Set Copy #1 of backup set 1 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------------- ---------- --- DISK 00:00:59 19-FEB-15 NO longer List of Backup Pieces for backup set 1 copy #1 BP Key Pc # Status Piece Name ------- --- -------------- 1 1 AVAILABLE/u02/06pvkh2l_1_1 2 AVAILABLE/u02/06pvkh2l_2_1 3 3 AVAILABLE/u02/invalid Key Type LV Size Device type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4 Full 703.77 m disk 00:01:19 19-FEB-15 List of Datafiles in backup set 4 File LV Type Ckp SCN Ckp Time Name --------------------------------- 1 Full 3201428 19-FEB-15/u01/app/oracle/oradata/test/system01.dbf Backup Set Copy #1 of backup set 4 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ DISK 00:01:19 19-FEB-15 NO attached List of Backup Pieces for backup set 4 Copy #1 BP Key Pc # Status Piece Name ------- --- ----------- -------- 6 1 AVAILABLE/u02/disk1/0apvkm85_1_1 7 2 AVAILABLE/u02/ disk2/0apvkm85_2_1 8 3 AVAILABLE/u02/disk1/0apvkm85_3_1RMAN>