Oracle DBA Tips and Techniques

By Arjun Raja

EXP USING COMPRESSION

Posted by Arjun Raja on January 5, 2011

To include via normal export ( not datapump ) a named pipe and compress exports to save space and also backup the dump to tape.

First create parfile – u01/local/scripts/par/exp_full.par

parfile looks like this –

COMPRESS=N
DIRECT=Y
CONSISTENT=Y
STATISTICS=NONE
FULL=Y
FILE=pipe

Shell script export part –

# run exp

cd /u02/oradata/admin/db}/dpdump

rm /u02/oradata/admin/db/dpdump/*

/usr/sbin/mknod /u02/oradata/admin/db/dpdump/pipe p

/usr/bin/compress < /u02/oradata/admin/db/dpdump/pipe > /u02/oradata/admin/db/dpdump/db_full_exp_`date +%d%m%Y%H%M`.dmp.Z &

exp \’/ as sysdba\’ parfile=/u01/local/scripts/par/exp_full.par

dsmc backup *.Z

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: