You are managing an Oracle Database 11g database. You want to take the backup of
MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of
only 10 GB each.
Which method would accomplish the task quickly and efficiently?
A.
parallel image copy backup
B.
backup with MAXPIECESIZE configured for the channel
C.
parallel backup with MAXPIECESIZE configured for the channel
D.
intrafile parallel backup
Explanation:
The MAXPIECESIZE option is to limit the size of backup piece. not to split the big file into
pieces.
Configuring the Maximum Size of Backup Pieces
Backup piece size is an issue when it exceeds the maximum file size permitted by the file
system or media management software. You can use the MAXPIECESIZE parameter of the
CONFIGURE CHANNEL or ALLOCATE CHANNEL command to limit the size of backup
pieces.
For example, to limit the backup piece size to 2 gigabytes or less, you can configure the
automatic DISK channel as follows and then run BACKUP DATABASE:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G;BACKUP DATABASE;
We should use the SECTION SIZE option to split the big file into sections to the multiple
backup devices. SECTION SIZE sizeSpec Specifies the size of each backup section
produced during a data file backup.
By setting this parameter, RMAN can create a multisection backup. In a multisection backup,
RMAN creates a backup piece that contains one file section, which is a contiguous range of
blocks in a file. All sections of a multisection backup are the same size. You can create a
multisection backup for a data file, but not a data file copy.
File sections enable RMAN to create multiple steps for the backup of a single large data file.
RMAN channels can process each step independently and in parallel, with each channel
producing one section of a multisection backup set.
If you specify a section size that is larger than the size of the file, then RMAN does not use
multisection backup for the file. If you specify a small section size that would produce more
than 256 sections, then RMAN increases the section size to a value that results in exactly
256 sections.
Depending on where you specify this parameter in the RMAN syntax, you can specify
different section sizes for different files in the same backup job.
Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL
1.