Re: Export to tape
From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sun, 14 Dec 2003 23:41:16 -0600
Message-ID: <bLbDb.18477$Ob4.11660_at_bignews2.bellsouth.net>
Date: Sun, 14 Dec 2003 23:41:16 -0600
Message-ID: <bLbDb.18477$Ob4.11660_at_bignews2.bellsouth.net>
[Quoted] Ok, this is just a wild suggestion based on your limitations that I think you have.
How about installing something like Mks TookKit ( http://www.mkssoftware.com/ ) that will create a Unix-Like environment on Windows. This software is fairly cheap I think.
This environment might then allow the ability to either go directly to the tape device or use the "named pipe" method. I could explain the "named pipe" [Quoted] method if you want or you could search and probably find some examples.
Maybe someone more familiar than me with the Mks ToolKit could respond on the possibility of this.
-- "John Wood" <jwood_at_hotmail.com> wrote in message news:Ug8Db.10620$OJ.4247_at_edtnps84...Received on Mon Dec 15 2003 - 06:41:16 CET
> That is my issue here. The Window2000 OS cannot see the DLT drive
directly.
> But the Backup Utility can back up OS files to the DLT drive.
>
> For the Export Utility, it can only export to disk file (not like the Unix
> and VMS version). So I am not sure if there is any 3rd party utility that
> can bridge the gap.
>
> My database file is estimated to be 300G in 3 years. But I don't have
spare
> drive bay in the Server Rack. If I need extra disk space, it will cost
> considerably for external drive racks.
>
> Thanks.
>
> "Frank" <fbortel_at_nescape.net> wrote in message
> news:brf893$2ih$1_at_news2.tilbu1.nb.home.nl...
> > John Wood wrote:
> >
> > > 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
> > >>
> > >
> > >
> > >
> >
> > It's the 'Device Driver', that RMAN can use.
> > I used quotes, as it is not the same as a device driver
> > the OS can use - it needs hooks to the application(s), in
> > this case RMAN.
> > If you cannot use the DLT directly, (e.g. type boot.log>dlt)
> > I fail to see how you could export directly.
> >
> > How large is the export, anyway? Any chance of temporarily
> > storing on disk?
> > --
> > Regards, Frank van Bortel
> >
>
>