Oracle Database 12c: Advanced Administration — Question 71
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
Answer options
- A. image copy backup by using RMAN
- B. multisection image copy backup by using RMAN
- C. multisection parallel backup by using RMAN
- D. cold backup after taking the tablespace offline
- E. cold backup after placing the tablespace in backup mode
Correct answer: A
Explanation
An image copy backup using RMAN is the most efficient method for backing up large data files quickly, as it creates a direct copy of the data file. Other options, while they may provide some benefits, do not specifically address the need for improved performance in this context. For example, multisection backups can speed up the process but are not as straightforward as a simple image copy.