Re: export/import directly from tape drive? (UNIX)
Date: Fri, 4 Mar 1994 05:36:15 GMT
Message-ID: <CM4KwG.F2r_at_idm.com>
Barry Hannigan; EdTel (hannigan_at_cs.ualberta.ca) wrote:
> 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
^^^^^^^^^^^^^^^^^^^^^^^^^^ HUH?We are still using 6.0.37, so that may be the reason, but we import directly from tape all the time. This is running 9.04 on an 835, an 827, and an H70.
> 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 |
Tom Received on Fri Mar 04 1994 - 06:36:15 CET