Consider the following lines:

export pname=exp_pipe
cat $pname | compress > dumpfilename.dmp.Z &
$ORACLE_HOME/bin/exp parfile=parfilename.par file=$pname log=logfilename.log 2>/dev/null;

I have removed the directory names from all names in my script and tried to give you the basic lines only. Please be careful adding your directory or folder names to each of pipe name, parameter file name and dump and log file names for proper execution.

Also make sure that you have a pipe created in the correct folder before using above. You create pipe with the mknod command in unix, such as

mknod exp_pipe p


Gurmohan
www.freemath.info



----------------------------------------------------------------------------

-----Original Message-----
From: luis
[mailto:oracledba-ezmlmshield-x92088247.[Email address protected]
Sent: Wednesday, June 29, 2005 10:35 AM
To: LazyDBA Discussion
Subject: Backups and file system.


Gurues,


I am doing a backup by offlining the tablespaces and then copying the
datafiles across to a temporary location then I tar em off to tape and then
delete them.

I have struck a problem: SPACE.


instead of copying one at a time a need to copy to a tarfile and append to
it. I think there is a way of taring through a pipe or compressing on the
fly or something like that so any imput into this will prove extremely
valuable.

Currently I use

SQL> host cp /u14/oradata/PRD1/tasaudit_01.dbf /u05/tmpbackup/dbs


/u05 fills up therefore I have incomplete backups.


Thank you very much.


Luis



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page