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 to tape

Re: Export to tape

From: John Wood <jwood_at_hotmail.com>
Date: Tue, 16 Dec 2003 05:12:55 GMT
Message-ID: <rvwDb.15770$OJ.14888@edtnps84>

Frank,
Thanks for your suggestion. I will search through the net on it. But I still hope some one can give me some more idea. Thanks.
JW
"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message news:bLbDb.18477$Ob4.11660_at_bignews2.bellsouth.net...
> 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"
> 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...
> > 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
> > >
> >
> >
>
>
Received on Mon Dec 15 2003 - 23:12:55 CST

Original text of this message

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