Looking for an idea of best practice to backup Oracle DB on a remote server...

[Tom Brown]

> I have a PE2850 running RHEL4ES 64Bits and Oracle 10G database.
> 
> My problem is that i need to create a dump of the database but i have not
> enough free disk space on this server...
> 
> So i am looking for a way to do it using the free disk space of a remote
> server...(linux or windows dell servers too).
> 
> Any idea ? NFS, Samba ?
> 
> Thanks
> 
> PS : i'm really a beginner at Linux and Oracle, and the one that has created
> this server has been fired  ;-((

you could install the oracle exp client on another machine and run the 
exp over the network (i do this in production as another form of backup)

you could also run it to a named pipe or similar with something like

On TARGET machine

  1. mknod /tmp/inpipe.dmp p
  2. imp xxx/xxx file=inpipe.dmp &   (bg is optional; I do it to make
  sure it blocks)

  On SOURCE machine

  3. mknod /tmp/outpipe p
  4. ssh -C user at targethost 'cat > /tmp/inpipe.dmp' < /tmp/outpipe &
  5. exp xxx/xxx file=/tmp/outpipe

note: the above sequence came from a post to an oracle newsgroup but i 
don't have the name of the original poster. I can't claim to have come 
up with the above