Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exporting Directly to Tape

Re: Exporting Directly to Tape

From: Helena Whitaker <helena_at_CREIGHTON.EDU>
Date: Wed, 27 Dec 1995 11:05:15 -0600
Message-Id: <>

On Wed, 27 Dec 1995, Kilner, Carol wrote:

> Has any one had any experience doing an export directly to dat tape on an
> HP-UX version 10.

> I specify the tape drive as the export location i.e. /dev/rmt/0mbd and
> export a few tables. Everything seems to work okay.
> I then re-wind the tape and copy the backup onto disk and try to do an
> import.
> I use: dd if = /dev/rmt/0mb
> I then run imp and use this as the import file. I promptly get an error
> . importing CTSSYS's objects into CTSSYS
> IMP-00032: SQL statement exceeded buffer length
> IMP-00009: abnormal end of export file
> Import terminated successfully with warnings.
> $
> I tried increasing the size of the buffer but this didn't seem to work. The
> message also indicates it might be because the import file is corrupted.
> Can anyone shed some light onto this issue?

        I'm not on HP-UX 10 yet, but when I export to tape under
        HP-UX 9.0.4, I always import directly from tape.

        Are you sure dd can copy an export file properly from tape
        to disk ?  (I once had a problem where one version of frecover
        improperly handled copying an fbackup file written under another
        version ... copy seemed ok but Oracle couldn't read the database
        file ... so I wouldn't be sure that dd can copy a file that
        oracle wrote directly to tape).

        My gut feeling is that export/import directly to/from tape
        will be consistent, export/import to/from disk with a dd to
        tape as a backup will be consistent, but export to tape,
        dd to disk, import from disk may not be.



<: Helena Whitaker, DBA                :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Computer Center                                fax  (402)280-2573 :>
<: 2500 California Plaza                Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046                      HP 9000/H50, /E25, /842 :>
<: (also Nebraska            Oracle Banner Finance 2.0.3 :>
<:  Oracle Users Group)     Oracle Patient Accounting :>

Received on Wed Dec 27 1995 - 12:11:01 CST

Original text of this message