Re: Export to tape

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 Sun Dec 14 2003 - 19:39:00 CST