Actually I’m upgrading a database (Release 9.2.5.0) to 12c, It is a small database because of this I prefer perform a (traditional) exp and imp that upgrade to a 10g and after that upgrade to 12c.
The problem I have found is when generate the dmp file, the file system have 20 gigas of free space and the dmp file size is greater. There are some solutions, in my case I selected compress the dmp file while it is generated using a unix pipe. Here I show the script;
orange-3@> cat dumper.sh #!/bin/ksh export ORACLE_SID=FINAN export ORACLE_HOME=/oracle/server/925 DIRECTORY=/dummy; export DIRECTORY FILENAME=${DIRECTORY}/fichero_grande.dmp.gz; export FILENAME LOG=${DIRECTORY}/fichero_grande.log; export LOG PIPE=${DIRECTORY}/export_pipe.dmp; export PIPE test -p ${PIPE} || mknod ${PIPE} p chmod +rw ${PIPE} cat $PIPE | /usr/bin/gzip > ${FILENAME} & ${ORACLE_HOME}/bin/exp log=${LOG} buffer=104857600 file=${PIPE} owner=FINANCIAL << EOF financial/xxxxxxxxxx EOF
HTH – Antonio NAVARRO
Advertisements