Which two statements about multi section backup are true?

Which two statements about multi section backup are true?

Which two statements about multi section backup are true?

A.
It is available only for full backups.

B.
It supports incremental backups and image copies.

C.
Backup for each data file is divided into sections and is backed up in parallel. However, for
image copies, sections are backed up sequentially.

D.
For image copies, sections are backed up in parallel and recomposed at the end.

Explanation:
http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm (search for
multi section backup)

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Sunil Vora

Sunil Vora

B,D are the correct answers

Reply

Prateek

Prateek

Answer : B,D

Explanation :
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV380

Specifying Multisection Incremental Backups
A multisection backup enables large data files to be divided into sections that can be backed up in parallel across multiple channels. This provides faster backup performance and better recovery times. A multisection backup contains multiple backup pieces. During a multisection backup operation, RMAN writes to each backup piece, in parallel, by using a separate channel for each backup piece.

Multisection full backups of databases and data files are supported starting with Oracle Database 11g Release 1. Starting with Oracle Database 12c Release 1 (12.1), RMAN supports multisection incremental backups. Wherever applicable, RMAN also uses unused block compression and block change tracking while creating multisection incremental backups. When backup sets are used, you can create multisection full or incremental backups.

Making Multisection Backups Using Image Copies
RMAN enables you to create multisection backups using image copies. Multisection backups provide better performance by using multiple channels to back up large files in parallel. Starting with Oracle Database 12c Release 1 (12.1), you can create multisection full backups that are stored as image copies. While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file.

Use the SECTION SIZE clause to create multisection backups. If the section size that you specify is larger than the size of the file, then RMAN does not use multisection backups for that 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

Reply