Re: Export to tape

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Fri, 12 Dec 2003 12:20:51 -0600
Message-ID: <BEnCb.6731$Ob4.3660_at_bignews2.bellsouth.net>


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...

> 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
> >
>
>
Received on Fri Dec 12 2003 - 19:20:51 CET

Original text of this message