Speed up Data Pump Import by suppressing redo generation
Customer Request : Import 20GB Dump file without downtime(Without changing into noarchivelog mode). Problem: Database running in Archive log mode and my archive destination size is very limited. Solution: Using transform=disable_archive_logging:Y we can avoid redo generation and it will speedup import. Test: Without Feature: ============ Before Import: SQL> select * from v$recovery_area_usage where FILE_TYPE='ARCHIVED LOG'; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID ----------------------- ------------------ ------------------------- --------------- ---------- ARCHIVED LOG 1.74 0 7 ...