Oracle 12c 新特性 --- 数据泵导入时取消日志记录选项 TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

最新推荐文章于 2022-06-21 15:53:03 发布

原创

最新推荐文章于 2022-06-21 15:53:03 发布 · 2.1k 阅读

收录于

介绍了Oracle数据泵导入工具impdp的最新特性，DISABLE_ARCHIVE_LOGGING选项允许在导入数据和创建索引时禁用重做日志记录，从而减少所需磁盘空间。然而，为了确保从媒体故障中恢复，DBA应在导入完成后执行RMAN备份。此特性减少了DBA对重做日志的维护需求。

概念

The new TRANSFORM option, DISABLE_ARCHIVE_LOGGING, to the impdp command line causes Oracle Data Pump to disable redo logging when loading data into tables and when creating indexes. It also adds the same option as part of the PL/SQL DBMS_DATAPUMP package. With redo logging disabled, the disk space required for redo logs during an Oracle Data Pump import is 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.

This feature reduces the required maintenance of redo logs by DBAs.

新的转换选项，DISABLE_ARCHIVE_LOGGING，到impdp命令