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 tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?
A.
intrafile parallel backup
B.
parallel image copy backup
C.
backup with MAXPIECESIZE configured for the channel
D.
parallel backup with MAXPIECESIZE configured for the channel
Hello colleagues,
Why we cannot set a MAXPIECESIZE for 10 channels?
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