Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export directly to tape

Re: Export directly to tape

From: Markus Korn <markus.korn_at_at.siemens.de>
Date: Fri, 25 Jun 1999 13:25:10 +0200
Message-ID: <37736716.1435FB38@at.siemens.de>


A named pipe should help:

  1. make the named pipe: mknod exportPipe p
  2. start a backround job which reads the pipe and tarīs the output to tape tar "options" < exportPipe &
  3. Start the input into the pipe exp userid=system/manager full=y file=exportPipe

Note: you can also do a zip or compress with the same pipe!

Adam Knight wrote:
>
> Does anyone do their exports directly to tape?
>
> At present I export to .dmp files on a number of disks then write the
> disks to tape.
> Obviously that is two seperate operations.
>
> We are using Oracle8i on SUN Solaris 2.6.
>
> I now have a 36GB database which I want to export but doing that first
> to disk and then to tape is not possible (not enough spare disks to
> house the export files). I want to export directly to tape.
>
> Does anyone have any experience of doing this that they would like to
> share, please respond to the newsgroup if you do.
>
> Thanks in advance
>
> --
> Adam J M Knight
> Oracle DBA
> LEAP/MIS
> University of Bath
> Claverton Down
> Bath
> Somerset
> BA2 7AY
Received on Fri Jun 25 1999 - 06:25:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US