Friday, June 10, 2011

RMAN MultiSection backup example


RMAN> backup tablespace system section size 20M format '/tmp/%s_%p_%t';

Starting backup at 10-JUN-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 1 through 2560
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/tmp/37_1_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 2561 through 5120
channel ORA_DISK_1: starting piece 2 at 10-JUN-11
channel ORA_DISK_1: finished piece 2 at 10-JUN-11
piece handle=/tmp/37_2_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 5121 through 7680
channel ORA_DISK_1: starting piece 3 at 10-JUN-11
channel ORA_DISK_1: finished piece 3 at 10-JUN-11
piece handle=/tmp/37_3_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 7681 through 10240
channel ORA_DISK_1: starting piece 4 at 10-JUN-11
channel ORA_DISK_1: finished piece 4 at 10-JUN-11
piece handle=/tmp/37_4_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 10241 through 12800
channel ORA_DISK_1: starting piece 5 at 10-JUN-11
channel ORA_DISK_1: finished piece 5 at 10-JUN-11
piece handle=/tmp/37_5_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 12801 through 15360
channel ORA_DISK_1: starting piece 6 at 10-JUN-11
channel ORA_DISK_1: finished piece 6 at 10-JUN-11
piece handle=/tmp/37_6_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 15361 through 17920
channel ORA_DISK_1: starting piece 7 at 10-JUN-11
channel ORA_DISK_1: finished piece 7 at 10-JUN-11
piece handle=/tmp/37_7_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 17921 through 20480
channel ORA_DISK_1: starting piece 8 at 10-JUN-11
channel ORA_DISK_1: finished piece 8 at 10-JUN-11
piece handle=/tmp/37_8_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 20481 through 23040
channel ORA_DISK_1: starting piece 9 at 10-JUN-11
channel ORA_DISK_1: finished piece 9 at 10-JUN-11
piece handle=/tmp/37_9_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 23041 through 25600
channel ORA_DISK_1: starting piece 10 at 10-JUN-11
channel ORA_DISK_1: finished piece 10 at 10-JUN-11
piece handle=/tmp/37_10_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 25601 through 28160
channel ORA_DISK_1: starting piece 11 at 10-JUN-11
channel ORA_DISK_1: finished piece 11 at 10-JUN-11
piece handle=/tmp/37_11_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 28161 through 30720
channel ORA_DISK_1: starting piece 12 at 10-JUN-11
channel ORA_DISK_1: finished piece 12 at 10-JUN-11
piece handle=/tmp/37_12_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 30721 through 33280
channel ORA_DISK_1: starting piece 13 at 10-JUN-11
channel ORA_DISK_1: finished piece 13 at 10-JUN-11
piece handle=/tmp/37_13_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 33281 through 35840
channel ORA_DISK_1: starting piece 14 at 10-JUN-11
channel ORA_DISK_1: finished piece 14 at 10-JUN-11
piece handle=/tmp/37_14_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/prorcl/system01.dbf
backing up blocks 35841 through 38400
channel ORA_DISK_1: starting piece 15 at 10-JUN-11
channel ORA_DISK_1: finished piece 15 at 10-JUN-11
piece handle=/tmp/37_15_753469963 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 10-JUN-11
channel ORA_DISK_1: finished piece 1 at 10-JUN-11
piece handle=/tmp/52_1_753469979 tag=TAG20110610T171243 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-JUN-11




BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 175.91M DISK 00:00:15 10-JUN-11
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 485799 10-JUN-11 /u01/app/oracle/oradata/prorcl/system01.dbf

Backup Set Copy #1 of backup set 11
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:15 10-JUN-11 NO TAG20110610T171243

List of Backup Pieces for backup set 11 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
33 1 AVAILABLE /tmp/37_1_753469963
34 2 AVAILABLE /tmp/37_2_753469963
35 3 AVAILABLE /tmp/37_3_753469963
36 4 AVAILABLE /tmp/37_4_753469963
37 5 AVAILABLE /tmp/37_5_753469963
38 6 AVAILABLE /tmp/37_6_753469963
39 7 AVAILABLE /tmp/37_7_753469963
40 8 AVAILABLE /tmp/37_8_753469963
41 9 AVAILABLE /tmp/37_9_753469963
42 10 AVAILABLE /tmp/37_10_753469963
43 11 AVAILABLE /tmp/37_11_753469963
44 12 AVAILABLE /tmp/37_12_753469963
45 13 AVAILABLE /tmp/37_13_753469963
46 14 AVAILABLE /tmp/37_14_753469963
47 15 AVAILABLE /tmp/37_15_753469963