题目:
132.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
参考答案 D
解析
题目意思是,11g的数据库,想备份一个bigfile类型的表空间mult_data,大小为100T。每个磁带的大小是10G,使用哪种方法可以快速高效地完成备份。使用并行。 选择D 。
参考文档:
3.11 Recovery Manager
Oracle Recovery Manager (RMAN) is an Oracle Database utility to manage database backup and, more importantly, the recovery of the database. RMAN eliminates operational complexity while providing superior performance and availability of the database.
RMAN determines the most efficient method of executing the requested backup, restoration, or recovery operation and then submits these operations to the Oracle Database server for processing. RMAN and the server automatically identify modifications to the structure of the database and dynamically adjust the required operation to adapt to the changes.
RMAN provides the following benefits:
-
Automatic channel failover on backup and restore operations
-
Automatic failover to a previous backup when the restore operation discovers a missing or corrupt backup
-
Automatic creation of new database files and temporary files during recovery
-
Automatic recovery through a previous point-in-time recovery—recovery through resetlogs
-
Block media recovery, which enables the data file to remain online while fixing the block corruption
-
Fast incremental backups using block change tracking
-
Fast backup and restore operations with intrafile and interfile parallelism
-
Lower space consumption when creating a database over the network by eliminating staging areas
-
Merger of incremental backups into image copies in the background, providing up-to-date recoverability
-
Optimized backup and restore of required files only
-
Retention policy to ensure that relevant backups are retained
-
Ability to resume backup and restore of previously failed operations
-
Automatic backup of the control file and the server parameter file, ensuring that backup metadata is available in times of database structural changes and media failure and disasters
-
Online backup that does not require you to place the database into hot backup mode
For more information, see the Oracle Database Backup and Recovery User's Guide.
END