QUESTION 57-12c 数据泵导入时禁止生成日志的参数disable_archive_logging

Examine the following query output:
SQL> SELECT name, force_logging FROM V$DATABASE
NAME FORCE_LOGGING
-------------------- ------------------------
PROD NO
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
A. All database operations performed by the impdp command are logged.
B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
Correct Answer: C

Note from Oracle Documentation: With redo logging disabled, the disk space required for redo logs during an Oracle Data Pump import will be smaller.
However, to ensure recovery from media failure, the DBA should do an RMAN backup after the import completes. Even with this parameter specified, there is still redo logging for other operations of Oracle Data Pump. This includes all CREATE and ALTER statements, except CREATE INDEX, and all operations against the master table used by Oracle Data Pump during the import.

 

从Oracle文档:禁用重做日志，在Oracle数据泵导入过程中，重做日志所需的磁盘空间会更小。

但是，为了确保从介质故障中恢复，DBA应该在导入完成后执行RMAN备份。即使指定了这个参数，Oracle数据泵的其他操作仍然会有重做日志。这包括除了CREATE INDEX之外的所有CREATE和ALTER语句，以及在导入过程中Oracle Data Pump对主表使用的所有操作。