Which method would accomplish the task quickly and efficiently?

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.
Which method would accomplish the task quickly and efficiently?

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.
Which method would accomplish the task quickly and efficiently?

A.
parallel image copy backup

B.
backup with MAXPIECESIZE configured for the channel

C.
parallel backup with MAXPIECESIZE configured for the channel

D.
intrafile parallel backup



Leave a Reply 1

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


Justyna

Justyna

Maybe possible but there a new method called intra-file parallel backup for Big Tablespaces:

“With the size of enterprise databases continuing to grow – it has become more advantageous to take advantage of Bigfile Tablespaces. Yet another innovation from Oracle, a Bigfile Tablespace is made up of a single large file rather than numerous smaller files, allowing Oracle Databases to scale up to 8 exabytes in size. Oracle Database 11g features an enhanced Recovery Manager (RMAN) tool that can perform intra-file parallel backup and recovery operations for Bigfile Tablespaces, thereby making the backups and restore operations significantly faster.”
http://www.oracle.com/technetwork/database/performance/db-perfscale-11gr1-twp-129806.pdf