Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export to tape
We use to export direct to tape on Unix.
So, not sure this helps you on Windows, but all it took was the following in the export parameter file:
file=/dev/rmt/0mn
-- "John Wood" <jwood_at_hotmail.com> wrote in message news:uUjCb.62750$bC.22476_at_clgrps13...Received on Fri Dec 12 2003 - 12:20:51 CST
> Frank,
>
> Thanks for replying.
>
> I will use RMAN for backup. But I still want to use Export to tape. As
the
> total database file size (both data and index) is estimated to be about
300
> to 400G, I prefer not to buy extra external SCSI drive System. So I
would
> like to test on tapes.
>
> By the way, what's the libraries for RMAN to write to tape ?
>
> Thanks again.
>
> JW
>
> "Frank" <fbortel_at_nescape.net> wrote in message
> news:brbt3h$kgt$1_at_news4.tilbu1.nb.home.nl...
> > John Wood wrote:
> > > Hi there,
> > > I use Oracle 9.2 in Window 2000 environment. I have SCSI DLT Tape
drive. I
> > > would like to run Export directly onto the tapes. Is there anyway to
do
> > > this ? What should I use ? Will Legato do that ?
> > > Thanks in advance.
> > > JW
> > >
> > >
> >
> > Export is NOT a backup - it's data, not the physical layout.
> > If you were provided the libraries for Oracle, look into RMAN.
> > RMAN can write to tape (provided previous named libraries are
> > availbale), and handle hot and cold backups.
> >
> > Export only writes to files; so you must be able to make exp
> > see your tape as a file(system). 3rd party tools should be
> > able to do that, but the "run Export directly onto the tapes"
> > remains iffy.
> >
> > I'd go for RMAN
> > --
> > Regards, Frank van Bortel
> >
>
>