backup bigfile tablespace – Laurent Schneider

One may pretend bigfile tablespace is bad, because you cannot backup/restore in parallel.

SQL> create bigfile tablespace big datafile size 1g;


Tablespace created.
RMAN> configure device type disk parallelism 4;
using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 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 tablespace big section size 100m;

Starting backup at 30.11.2007 07:23:30 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=44 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=42 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=41 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=40 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 1 through 12800 channel ORA_DISK_1: starting piece 1 at 30.11.2007 07:23:37 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 12801 through 25600 channel ORA_DISK_2: starting piece 2 at 30.11.2007 07:23:41 channel ORA_DISK_3: starting compressed full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 25601 through 38400 channel ORA_DISK_3: starting piece 3 at 30.11.2007 07:23:45 channel ORA_DISK_4: starting compressed full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 38401 through 51200 channel ORA_DISK_4: starting piece 4 at 30.11.2007 07:23:48 channel ORA_DISK_1: finished piece 1 at 30.11.2007 07:23:49 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_1_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 51201 through 64000 channel ORA_DISK_1: starting piece 5 at 30.11.2007 07:23:53 channel ORA_DISK_2: finished piece 2 at 30.11.2007 07:23:53 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_2_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:12 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 64001 through 76800 channel ORA_DISK_2: starting piece 6 at 30.11.2007 07:23:57 channel ORA_DISK_3: finished piece 3 at 30.11.2007 07:23:57 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_3_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:12 channel ORA_DISK_3: starting compressed full datafile backup set channel ORA_DISK_3: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 76801 through 89600 channel ORA_DISK_3: starting piece 7 at 30.11.2007 07:24:01 channel ORA_DISK_1: finished piece 5 at 30.11.2007 07:24:01 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_5_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 89601 through 102400 channel ORA_DISK_1: starting piece 8 at 30.11.2007 07:24:05 channel ORA_DISK_2: finished piece 6 at 30.11.2007 07:24:05 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_6_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:08 channel ORA_DISK_2: starting compressed full datafile backup set channel ORA_DISK_2: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 102401 through 115200 channel ORA_DISK_2: starting piece 9 at 30.11.2007 07:24:09 channel ORA_DISK_4: finished piece 4 at 30.11.2007 07:24:09 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_4_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:21 channel ORA_DISK_4: starting compressed full datafile backup set channel ORA_DISK_4: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 115201 through 128000 channel ORA_DISK_4: starting piece 10 at 30.11.2007 07:24:13 channel ORA_DISK_1: finished piece 8 at 30.11.2007 07:24:13 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_8_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00007 name=/oradata/LSC08/datafile/o1_mf_big_3nzbd7h5_.dbf backing up blocks 128001 through 131072 channel ORA_DISK_1: starting piece 11 at 30.11.2007 07:24:18 channel ORA_DISK_2: finished piece 9 at 30.11.2007 07:24:18 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_9_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:09 channel ORA_DISK_3: finished piece 7 at 30.11.2007 07:24:18 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_7_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:17 channel ORA_DISK_4: finished piece 10 at 30.11.2007 07:24:18 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_10_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_4: backup set complete, elapsed time: 00:00:05 channel ORA_DISK_1: finished piece 11 at 30.11.2007 07:24:19 piece handle=/opt/oracle/product/11/db_4/dbs/01j2avjk_11_1 tag=TAG20071130T072332 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 30.11.2007 07:24:19

This works fine 😉

SECTION SIZE requires 11gR1 or later

5 thoughts on “backup bigfile tablespace”

Maurits Groenenberg April 14, 2009 at 15:32

thank you for the information Laurent!
Michael Chang July 10, 2009 at 02:32

Laurent,
Have you try to do full db backup with multiple bigfile tablespace? I could not find any example from Oracle doc.
Also, is there way to recover bigfile in parallel?
Thanks,
Michael
Laurent Schneider Post authorJuly 10, 2009 at 13:13

Yes you can backup/recover a bigfile in parallel

backup datafile ‘f1.dbf’ section size 1G;

so it will create 1G backup piece, that can be restored and backup in parallel.

However this is a 11g feature…
Michael Chang July 10, 2009 at 22:24

@Laurent Schneider
Can you do the following –
recover datafile ‘f1.dbf’ section size 1g;
Laurent Schneider Post authorJuly 11, 2009 at 09:26

no, you backup in small (1g) sections, then Oracle will be able to do the recover in parallel.

If you backup the datafile in only one piece (as in 10g), then no, there is no possible parallelism

Comments are closed.