1) SYSBACKUP role - Separations of duties.
2) Can use sql queries in RMAN utility.
RMAN> select * from manzoor.emp where rownum <
10;
EMPNO
ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ---------
---------- ----------
336
UVSVEEEXXP DEVELOPER 2341
05-OCT-14 12152 2222
337
NSOGZZVAEN DEVELOPER 2341
04-OCT-14 17363 2222
338
TEMNLPCVGF DEVELOPER 2341
03-OCT-14 12535 2222
339
DUZKTTXZIL DEVELOPER 2341
02-OCT-14 19725 2222
340
URGBOHUTYV DEVELOPER 2341
01-OCT-14 11987 2222
341
HSOKEDKCQL DEVELOPER 2341
30-SEP-14 13103 2222
342
XMAFFJPBPE DEVELOPER 2341
29-SEP-14 10511 2222
343
DNFUPTSKDO DEVELOPER 2341
28-SEP-14 10822 2222
344
HFWCUMIXWP DEVELOPER 2341
27-SEP-14 10586 2222
Multisection incremental backup in RMAN
RMAN> configure channel device type disk format
'/oracle/purchase_bkp/purchase_bkp_%U.bkp';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/purchase_bkp/purchase_bkp_%U.bkp';
new RMAN configuration parameters are successfully
stored
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 4
BACKUP TYPE TO COMPRESSED BACKUPSET;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE
TO COMPRESSED BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE
TO COMPRESSED BACKUPSET;
new RMAN configuration parameters are successfully
stored
RMAN> backup incremental level 0 section size 25M
datafile '/u01/app/oracle/oradata/purchase/active_data01.dbf';
Starting backup at 08-SEP-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 1 through 3200
channel ORA_DISK_1: starting piece 1 at 08-SEP-15
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 3201 through 6400
channel ORA_DISK_2: starting piece 2 at 08-SEP-15
channel ORA_DISK_3: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 6401 through 9600
channel ORA_DISK_3: starting piece 3 at 08-SEP-15
channel ORA_DISK_4: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002 name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 9601 through 12800
channel ORA_DISK_4: starting piece 4 at 08-SEP-15
channel ORA_DISK_1: finished piece 1 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_1_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 12801 through 16000
channel ORA_DISK_1: starting piece 5 at 08-SEP-15
channel ORA_DISK_2: finished piece 2 at 08-SEP-15
piece handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_2_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:00
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 16001 through 19200
channel ORA_DISK_2: starting piece 6 at 08-SEP-15
channel ORA_DISK_3: finished piece 3 at 08-SEP-15
piece handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_3_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_3: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 19201 through 22400
channel ORA_DISK_3: starting piece 7 at 08-SEP-15
channel ORA_DISK_1: finished piece 5 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_5_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 22401 through 25600
channel ORA_DISK_1: starting piece 8 at 08-SEP-15
channel ORA_DISK_2: finished piece 6 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_6_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 25601 through 28800
channel ORA_DISK_2: starting piece 9 at 08-SEP-15
channel ORA_DISK_4: finished piece 4 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_4_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_4: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 28801 through 32000
channel ORA_DISK_4: starting piece 10 at 08-SEP-15
channel ORA_DISK_1: finished piece 8 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_8_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 32001 through 35200
channel ORA_DISK_1: starting piece 11 at 08-SEP-15
channel ORA_DISK_2: finished piece 9 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_9_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 35201 through 38400
channel ORA_DISK_2: starting piece 12 at 08-SEP-15
channel ORA_DISK_3: finished piece 7 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_7_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:03
channel ORA_DISK_3: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 38401 through 41600
channel ORA_DISK_3: starting piece 13 at 08-SEP-15
channel ORA_DISK_1: finished piece 11 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_11_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 41601 through 44800
channel ORA_DISK_1: starting piece 14 at 08-SEP-15
channel ORA_DISK_2: finished piece 12 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_12_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 44801 through 48000
channel ORA_DISK_2: starting piece 15 at 08-SEP-15
channel ORA_DISK_4: finished piece 10 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_10_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_4: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 48001 through 51200
channel ORA_DISK_4: starting piece 16 at 08-SEP-15
channel ORA_DISK_1: finished piece 14 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_14_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 51201 through 54400
channel ORA_DISK_1: starting piece 17 at 08-SEP-15
channel ORA_DISK_2: finished piece 15 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_15_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 54401 through 57600
channel ORA_DISK_2: starting piece 18 at 08-SEP-15
channel ORA_DISK_3: finished piece 13 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_13_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_3: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 57601 through 60800
channel ORA_DISK_3: starting piece 19 at 08-SEP-15
channel ORA_DISK_1: finished piece 17 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_17_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 60801 through 64000
channel ORA_DISK_1: starting piece 20 at 08-SEP-15
channel ORA_DISK_2: finished piece 18 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_18_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_4: finished piece 16 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_16_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: finished piece 20 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_20_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:00
channel ORA_DISK_3: finished piece 19 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_3cqgkfi1_19_1.bkp
tag=TAG20150908T082225 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:00
Finished backup at 08-SEP-15
RMAN> backup incremental level 1 section size 25M
datafile '/u01/app/oracle/oradata/purchase/active_data01.dbf';
Starting backup at 08-SEP-15
using target database control file instead of
recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=54 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=56 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=67 device type=DISK
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 1 through 3200
channel ORA_DISK_1: starting piece 1 at 08-SEP-15
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 3201 through 6400
channel ORA_DISK_2: starting piece 2 at 08-SEP-15
channel ORA_DISK_3: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 6401 through 9600
channel ORA_DISK_3: starting piece 3 at 08-SEP-15
channel ORA_DISK_4: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 9601 through 12800
channel ORA_DISK_4: starting piece 4 at 08-SEP-15
channel ORA_DISK_1: finished piece 1 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_1_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 12801 through 16000
channel ORA_DISK_1: starting piece 5 at 08-SEP-15
channel ORA_DISK_2: finished piece 2 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_2_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 16001 through 19200
channel ORA_DISK_2: starting piece 6 at 08-SEP-15
channel ORA_DISK_3: finished piece 3 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_3_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_3: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 19201 through 22400
channel ORA_DISK_3: starting piece 7 at 08-SEP-15
channel ORA_DISK_1: finished piece 5 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_5_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 22401 through 25600
channel ORA_DISK_1: starting piece 8 at 08-SEP-15
channel ORA_DISK_2: finished piece 6 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_6_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 25601 through 28800
channel ORA_DISK_2: starting piece 9 at 08-SEP-15
channel ORA_DISK_4: finished piece 4 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_4_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_4: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 28801 through 32000
channel ORA_DISK_4: starting piece 10 at 08-SEP-15
channel ORA_DISK_1: finished piece 8 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_8_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:00
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 32001 through 35200
channel ORA_DISK_1: starting piece 11 at 08-SEP-15
channel ORA_DISK_2: finished piece 9 at 08-SEP-15
piece handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_9_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 35201 through 38400
channel ORA_DISK_2: starting piece 12 at 08-SEP-15
channel ORA_DISK_3: finished piece 7 at 08-SEP-15
piece handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_7_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_3: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 38401 through 41600
channel ORA_DISK_3: starting piece 13 at 08-SEP-15
channel ORA_DISK_1: finished piece 11 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_11_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 41601 through 44800
channel ORA_DISK_1: starting piece 14 at 08-SEP-15
channel ORA_DISK_2: finished piece 12 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_12_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 44801 through 48000
channel ORA_DISK_2: starting piece 15 at 08-SEP-15
channel ORA_DISK_4: finished piece 10 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_10_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:03
channel ORA_DISK_4: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 48001 through 51200
channel ORA_DISK_4: starting piece 16 at 08-SEP-15
channel ORA_DISK_1: finished piece 14 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_14_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 51201 through 54400
channel ORA_DISK_1: starting piece 17 at 08-SEP-15
channel ORA_DISK_2: finished piece 15 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_15_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_2: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 54401 through 57600
channel ORA_DISK_2: starting piece 18 at 08-SEP-15
channel ORA_DISK_3: finished piece 13 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_13_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_3: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup
set
input datafile file number=00002
name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 57601 through 60800
channel ORA_DISK_3: starting piece 19 at 08-SEP-15
channel ORA_DISK_1: finished piece 17 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_17_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_1: starting compressed incremental
level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup
set
input datafile file number=00002 name=/u01/app/oracle/oradata/purchase/active_data01.dbf
backing up blocks 60801 through 64000
channel ORA_DISK_1: starting piece 20 at 08-SEP-15
channel ORA_DISK_2: finished piece 18 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_18_1.bkp tag=TAG20150908T082407
comment=NONE
channel ORA_DISK_2: backup set complete, elapsed
time: 00:00:01
channel ORA_DISK_4: finished piece 16 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_16_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed
time: 00:00:02
channel ORA_DISK_1: finished piece 20 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_20_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed
time: 00:00:00
channel ORA_DISK_3: finished piece 19 at 08-SEP-15
piece
handle=/oracle/purchase_bkp/purchase_bkp_40qgkfl7_19_1.bkp
tag=TAG20150908T082407 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed
time: 00:00:00
Finished backup at 08-SEP-15
-- Starting with 12c we can create multisection
image copies.
Backup as copy section size 500M database;
No comments:
Post a Comment