Exadata X2-2 1/4 RACK并行备份测试

[root@dm01db01 ~]# imageinfo Kernel version: 2.6.18-274.18.1.0.1.el5 #1 SMP Thu Feb 9 19:07:16 EST 2012 x86_64 Image version: 11.2.3.1.1.120607 Image activated: 2012-08-14 19:16:01 -0400 Image status: success System partition on device: /dev/mapper/VGExaDb-LVDbSys1 rman target / Recovery Manager: Release 11.2.0.2.0 - Production on Mon Sep 3 10:13:11 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. RMAN> show all; RMAN configuration parameters for database with db_unique_name DBM are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 12 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_dbm1.f'; # default RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name DBM List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 16384 SYSTEM *** +DATA_DM01/dbm/datafile/system.256.790880171 2 16384 SYSAUX *** +DATA_DM01/dbm/datafile/sysaux.257.790880183 3 16384 UNDOTBS1 *** +DATA_DM01/dbm/datafile/undotbs1.258.790880195 4 16384 UNDOTBS2 *** +DATA_DM01/dbm/datafile/undotbs2.260.790880213 5 1024 USERS *** +DATA_DM01/dbm/datafile/users.261.790880225 6 204800 TESTEXA *** +DATA_DM01/dbm/datafile/testexa.264.792624955 TESTEXA 表空间 已被填充满 先做串行备份测试 RMAN> run 2> { 3> allocate channel c1 type disk; 4> backup as compressed backupset incremental level 0 tablespace testexa channel c1; 5> } allocated channel: c1 channel c1: SID=589 instance=dbm1 device type=DISK Starting backup at 03-SEP-12 channel c1: starting compressed incremental level 0 datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00006 name=+DATA_DM01/dbm/datafile/testexa.264.792624955 channel c1: starting piece 1 at 03-SEP-12 channel c1: finished piece 1 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t101448_0.295.793016089 tag=TAG20120903T101448 comment=NONE channel c1: backup set complete, elapsed time: 00:08:25 Finished backup at 03-SEP-12 released channel: c1 备份200GB数据耗时 8分25s 使用并行度12 section size=1024MB的备份 RMAN> backup as compressed backupset section size 1024M incremental level 0 tablespace testexa; piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.493.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_5: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_7: finished piece 196 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.494.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_7: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_8: finished piece 197 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.495.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_8: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_2: finished piece 199 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.497.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_3: finished piece 200 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.498.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_9: finished piece 198 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.496.793017075 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_9: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: finished piece 25 at 03-SEP-12 piece handle=+RECO_DM01/dbm/backupset/2012_09_03/nnndn0_tag20120903t103006_0.323.793017059 tag=TAG20120903T103006 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:11 Finished backup at 03-SEP-12 耗时约90s