B, D
Depending on number of allocated channels (can be created serially/parallel).
Starting with Oracle Database 12c Release 1 (12.1), you can create multisection full backups that are stored as image copies. e.g.
backup as copy database section size 500m;
Thus, DE are my answers
The purpose of multisection backups is to enable RMAN channels to back up a single large file in parallel. RMAN divides the work among multiple channels, with each channel backing up one file section in a file.
here is the link https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database-advanced.html#GUID-F2D9FF2D-9E1C-4D38-AD8E-88B6B32F02B4
DE
https://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#:~:text=The%20purpose%20of%20multisection%20backups,of%20backups%20of%20large%20datafiles.
I think DE is correct because as the documentation says (https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database-advanced.html#GUID-BC32C333-F0EB-4F17-AD79-8882E224D2F4)
"If a multisection backup completes successfully, then no backup set generated during the backup contains a partial data file", so the conclusion is all four sections must be contained in backup set (E)
Reading at your link:
To make a multisection backup:
Start RMAN and connect to a target database and recovery catalog (if used).
If necessary, configure channel parallelism so that RMAN can make the backup parallel.
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database-advanced.html#GUID-F2D9FF2D-9E1C-4D38-AD8E-88B6B32F02B4
If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN creates a backup set in which each backup piece contains the blocks from one file section.
The option E mentions backup "sets" (more than one backup set), making the option wrong.
B, D : https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/glossary.html#GUID-44B5A820-D859-47F5-99CC-56A95AF4BB3E
You create a multisection backup by specifying the SECTION SIZE parameter on the BACKUP command. An RMAN channel can process each file section independently, either serially or in parallel. Thus, in a multisection backup, multiple channels can back up a single file.
DE
If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN can
create a multisection backup. In this case, a single backup set can contain multiple
backup pieces, each containing a file section. The purpose
D,E is the correct answer. The question is simply about RMAN Multisection backups and as per oracle docs "The purpose of multisection backups is to enable RMAN channels to back up a single large file in parallel."
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database-advanced.html#GUID-F2D9FF2D-9E1C-4D38-AD8E-88B6B32F02B4
Therefore this question should be answered assuming all the pre-requisties are already in place for multisection backups (eg SECTION SIZE parameter, enough channels allocated for parallelism)
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
mporislav
Highly Voted 3 years, 9 months agoRinD
3 years, 9 months ago2211094
Most Recent 7 months ago2211094
7 months agoantonica
10 months, 2 weeks agoantonica
10 months, 1 week agogreenday5494
1 year, 5 months agokaka321
1 year, 6 months ago_gio_
1 year, 7 months agoG_C
2 years, 4 months agoauwia
7 months, 1 week agoflaviogcmelo
2 years, 9 months agobrolem
2 years, 9 months agonobody347
3 years, 4 months agoDBA007
2 years, 11 months agoRinD
3 years, 9 months agoRinD
3 years, 9 months ago