Importing a dump file compressed with inline compression( used gzip)
I am currently doing a export on a database using Oracle 8.0.5 on Solaris 8. I am using inline compression with the gzip utility. I am trying to test importing my data back into the database, but when I run my shell script the import process hangs. Here is my scipt for the inline compression for the export process, it works fine:
. /oracle/oracle_env.sh
#NLS_LANG=American_America.US7ASCII; export NLS_LANG
# First create a named pipe
mknod exp_pipe p
#change permssions on the pipe
chmod 777 exp_pipe
# export afegdb db
#Set export dump file name: MMDD
DX=`date +%m%d.exp.gz`; export DX
exp ecedi/******* full=Y compress=Y log=/oracle/backups/export.log file=exp_pipe|/usr/bin/gzip < exp_pipe > $DX
# EOF afegdb_export
Now to import the the database into a test database, I just modified the script and changed it to do import, Like so:
. /oracle/oracle_env.sh
#NLS_LANG=American_America.US7ASCII; export NLS_LANG
# First create a named pipe
mknod imp_pipe p
#change permssions on the pipe
chmod 777 imp_pipe
# export afegdb db
#Set export dump file name: MMDD
DX=/database/exports/1125.exp.gz; export DX
imp ecedi/******* full=Y compress=Y log=/oracle/backups/import.log file=imp_pipe|/usr/bin/gunzip < imp_pipe > $DX
# EOF afegdb_export
The export script is one that tamilselvan provided in one of his post.
I am trying find out if I am going down the right path to import the data or I totally off track here?//
I have tried to do an straight export, but my export keeps bombing out and giving me the following errors:
EXP-00002: error in writing to export file
EXP-00222:
System error message 27
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
I checked the dmp file and it was over 2GB, but I checked my ulimit and it is set to unlimited, so I don't know what is happening there either. After checking for a solution all over, I am stumped at this point....I need help!! Any suggestions anyone. I apologize for the lenghty post here. thanks in advance.
Re: Importing a dump file compressed with inline compression( used gzip)
Sorry, I was talking and typing at the same time.
It looks to me as if the imp is trying to read from the pipe before gunzip has written anything to it, which might be the issue. Splitting that line, like ...
/usr/bin/gunzip < imp_pipe > $DX
imp ecedi/******* full=Y compress=Y log=/oracle/backups/import.log file=imp_pipe
... might be the fix