Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!news-xfer.cox.net!peer01.cox.net!cox.net!bigfeed.bellsouth.net!bignumb.bellsouth.net!news.bellsouth.net!bignews2.bellsouth.net.POSTED!not-for-mail From: "Burt Peltier" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools References: Subject: Re: Export to tape Lines: 61 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: X-Trace: ogjnolidcdijhjikdbdpiflmbcekedmfhojhikkbagflhcbojcdlkkgmjckhhpmcopfpcpbnmdmnelplkccmllboedjcojnpbanmbibeagkehceiihbbjoldfngcmehnlphiohipefipeeonnimjijeefldcoilp NNTP-Posting-Date: Fri, 12 Dec 2003 13:19:13 EST Date: Fri, 12 Dec 2003 12:20:51 -0600 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:133971 comp.databases.oracle.tools:83983 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" wrote in message news:uUjCb.62750$bC.22476@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" wrote in message > news:brbt3h$kgt$1@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 > > > >