Re: Export to tape

From: Frank <fbortel_at_nescape.net>
Date: Sat, 13 Dec 2003 15:47:21 +0100
Message-ID: <brf893$2ih$1@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 Sat Dec 13 2003 - 08:47:21 CST