Re: exp via pipe and compress

On Thu, 16 Jul 1998 16:13:13 GMT, sbatter_at_my-dejanews.com <sbatter_at_my-dejanews.com> wrote:
>
>
>I talked to oracle to get around > 2GB exp filesize limitation
>They suggest:
> cat < /dev/exp.pipe > compress.Z &
> exp userid/passwd file=/dev/exp.pipe .... &

They should have suggested you search MetaLink for 1015589.6

# 
#                      EXPORT WITH COMPRESS SCRIPT 
#                      --------------------------- 
# 
# BEFORE RUNNING THIS SCRIPT, USE the mknod command to create a named pipe 
# called /dev/PIPE.dmp (mknod is Unix command, PIPE.dmp is an arbitrary name). 
# Then set environment variables for ORACLE_HOME, ORACLE_SID, and DUMPDIR, as 
# well as PATH if needed. 
# If you save the script as, say, exp_comp.sh, type 
#       % exp_comp.sh &  
# at the Unix prompt to run it. 
# WARNING: You must have unique names for each pipe if you have 
# multiple concurrent executions of this script. 
 

trap '' 1 # nohup  

# Set these to appropriate values
ORACLE_HOME=
ORACLE_SID=
DUMPDIR=   # Customize PATH if needed
PATH=/bin:/usr/bin:${ORACLE_HOME}/bin:/usr/local/bin:/usr/lbin  

export ORACLE_HOME ORACLE_SID PATH
LOGFILE=$DUMPDIR/exp${ORACLE_SID}.log
exec >$LOGFILE 2>&1  

echo "Exporting $ORACLE_SID database. start `date`"  

# Customize this as needed
exp system/manager GRANTS=Y FULL=Y INDEXES=Y COMPRESS=Y FILE=/dev/PIPE.dmp &  

compress </dev/PIPE.dmp > $DUMPDIR/exp$ORACLE_SID.dmp.Z &  

Also, I put a sleep 30 before the exp to avoid sync problems. And run it in a sh derivative.

>
>this works fine on small exports. if i do a full the compress.Z file
>is corrupt. if i do zcat compress.Z | more i can see bad sql statements
>and garbase where my create and grant statements should be. Oracle support
>is being typical. The exp logfile reports export without warnings. So it looks
>like compress isnt reading from the pipe correctly.
>
>Exp to tape works but is at current 2 tapes and slow as sh*t.
>
>OS Solaris 2.6 ( recent recommended patches )
>Oracle 7.3.3.5.0
>hardware Sun Ultra 2 single 300Mhz
>
>Has anybody run into something similar? Am i doing something wrong?
>Are they any alternatives?
>
>TIA
>
>steve
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jul 17 1998 - 19:13:36 CDT