What type of backup do you recommend to improve the performance of the backup?

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?

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?

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



Leave a Reply 9

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


Fedo

Fedo

I think it’s C.

puntano

puntano

C. Me too

goszczu

goszczu

C but B also looks ok

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.

Cyril Jones

Cyril Jones

WHY NOT “A”