disable/decrease the generation of archived redolog files while importing

oracle oracle11g impdp
SamiBOB picture SamiBOB · Feb 13, 2012 · Viewed 8.1k times · Source

We have a shell script that we use to import a dump file into a database. This script literally calls impdp utility. But before doing so, it disable the Archivelog on the target database in order to disable generation of archived redolog files during this operation.

Recently, it became impossible for us to shutdown database before the impdp (technical requirement). This way the archivelog mode can't be disabled :-(

My question is , how can we still manage to decrease the number of generated archived redolog files while importing even when the database is in archivelog mode?

I tried to put all the permanent tablespaces in NOLOGGING Mode, but i still got a lot of archived redolog files generated ....

Answer

Mirkolum picture Mirkolum · Oct 5, 2016

With Oracle 12c you can disable the use of the redo logs (see Oracle Documentation)

impdp [...] transform=disable_archive_logging:y

This article from "Burleson" gives you an comprehensive overview.

Related questions

Migrating Oracle Database with expdp and impdp

Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a schema from one database (11g R1) to another (11g R2)? Currently I only can make tests with the 11g R1 …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More