Re: export/import directly from tape drive? (UNIX)

ag831_at_FreeNet.Carleton.CA (Denis Langlais) writes:

>In a previous article, mellis_at_ramcad.pica.army.mil (Mark Ellis) says:
 

>>
>>
>>Anyone have any tips/techniques on doing exports/imports directly
>>to & from a DAT tape drive under UNIX?
>>
>>The export files are now too big (even with on-the-fly compression).
>>We do UNIX filesystem backups to tape nightly, but an export would be
>>nice as well in case we have to migrate to another system for
>>disaster recovery.
>>
>>System: Oracle 7 on Hewlett-Packard I50 (HP/UX 9.0)
>>
 

>Basically export with file=/dev/rmt/xxxyyyzzz

you would be advised not to. you will be unable to import from tape. in order to retrieve information from a tape exported export, you must copy the tape to disk and then import from the copy. also, the file cannot be named FOO as imp will whine about not being able to find file FOO.dmp

architecture is HP 9000/887, v9.04 HPUX , Oracle 7.0.15, dbsize 10G

[flameage]
it takes a real brain surgeon to follow the logic that if we had the disk space to begin with, we wouldn't have exported the database to tape in the first place now would we

barry

--
   4 players            | barry hannigan             | 
   inferno              |  1960-10303 jasper ave     | death to videodrome
   nightmare            |  edmonton, alberta         | long live the new flesh
   deathmatch on net 666|  t5a 4k5                   |