Oracle DBA Tips and Techniques

By Arjun Raja

Archive for January, 2010

EXPORT ( EXPDP ) WITH COMPRESSION OF DUMPS IN 11g

Posted by Arjun Raja on January 21, 2010

Datapump in 11g has a good feature to reduce size of exports and resources used on machines and tapes by compressing the dumps as and when the export happens..

In version 10g, datapump did not have the compress option for data – only the default option to compress METADATA only.

Example in 10g –

TEST schema using datapump –

nohup expdp system/xxxxxx schemas=test directory=data_pump_dir dumpfile=test.dmp logfile=test.log &

Export took 2 hours 10 minutes.

Export dump size was 91 gb.

The same data was exported in 11g –

Only difference was adding the following bit to the expdp command in 11g – > compression=all

nohup expdp system/xxxx compression=all schemas=test
directory=data_pump_dir dumpfile=test.dmp logfile=test.log &

Export took 1 hour 15 minutes.

Export dump size – 13 gb

In 11g it took just over half the time and saved 7 times the space which will tremendously reduce the amount of data moved off to tape on a daily basis especially in some databases where exports are taken daily and moved to tape.

Also there is no need to use unix pipes or uncompress dumps before commencing the import as Oracle takes care of that.

Posted in Oracle 11g | Tagged: , | 2 Comments »

11g Release 2 installation of software – AIX.

Posted by Arjun Raja on January 4, 2010

Document attached on 11g release 2 installation on AIX box – only database software- click on link below.

11G_RELEASE2_INSTALLATION

Posted in Oracle 11g | Leave a Comment »