From: "John Wood" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools References: Subject: Re: Export to tape Lines: 44 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: Date: Fri, 12 Dec 2003 14:03:06 GMT NNTP-Posting-Host: 142.173.130.97 X-Trace: clgrps13 1071237786 142.173.130.97 (Fri, 12 Dec 2003 07:03:06 MST) NNTP-Posting-Date: Fri, 12 Dec 2003 07:03:06 MST 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 >