exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 124 discussion

Actual exam question from Oracle's 1z0-062
Question #: 124
Topic #: 1
[All 1z0-062 Questions]

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

  • A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  • B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  • C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
  • D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
  • E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
  • F. BACKUP SPFILE SECTION SIZE 1M;
  • G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
Show Suggested Answer Hide Answer
Suggested Answer: ABEG 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
khan
Highly Voted 5 years, 8 months ago
Answer: ABEG More info on RMAN Multisection Backups For backing up very large data files, RMAN provides multisection backups as a way to parallelize the backup operation within the file itself, such that sections of a file are backed up in parallel, rather than backing up on a per-file basis. For example, a one TB data file can be sectioned into ten 100 GB backup pieces, with each section backed up in parallel, rather than the entire one TB file backed up as one file. The overall backup time for large data files can be dramatically reduced. https://docs.oracle.com/database/121/VLDBG/GUID-FA70B6EF-0C8B-435B-98C9-CDEBCDCED145.htm#VLDBG1576
upvoted 5 times
jackymak
2 years, 9 months ago
Why are they multisection backup? Because they are separated as 100M per section? Or the tablespace are much larger than archive log, sp file and temp table?
upvoted 1 times
...
...
Ray520
Most Recent 2 years, 8 months ago
BACKUP ARCHIVELOG ALL SECTION SIZE 25M; This command does not fail, but only creates archivelog backups, not multi section backups. BACKUP SPFILE SECTION SIZE 1M; This command also does not fail, but only creates normal backup, not multi section backups.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago