tape export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tape export

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Thumbs up


    Can you export data to tape and direct the log file from the export to disk?
    I'm exporting to tape but my log file is pointing to disk.
    From my screen, I saw that the export went well with no problem.
    After the export I tried to open the log file but it did not work


    userid=****/*****
    full=y
    file=/dev/rmt0
    log=/oraclestuff/backup/export_log.log
    buffer=1111111

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Two things,

    First, what do you mean that you tried to open the logfile but it did not work? Did it create the log file and it was empty, or was the logfile still in use? How did you try to open it and was there any errors?

    Also, be sure to test an import with this export. I've seen problems when you do not use the VOLSIZE parameter, you may need it on export and import.

    From metalink....

    EXPORTING DIRECTLY TO TAPE
    --------------------------

    Once you have decided that you need to perform the export directly to tape,
    you will need to change the syntax of your export statement so that
    export knows the name of the tape device and how much data can be written
    to that tape device.

    There are only 2 parameters that you need to change to do this :

    1. FILE - The name of the tape device you are exporting to
    e.g. /dev/rmt/0 .

    2. VOLSIZE - The amount of data that can be written to one tape.

    If the entire export file will fit onto a single tape, then a volsize of
    0 (variable length) can be used i.e. exp volsize=0.
    If the resultant export file is larger than a single tape, then volsize
    needs to be set accordingly e.g. exp volsize=M.
    Please note, there is a 4 Gigabyte limit to the volsize parameter.
    Doug

  3. #3
    Join Date
    Nov 2000
    Posts
    169
    What I mean is that, the log file was created alright but when I did cat/more on the file to see the contents, I received this message: A file or directory in the path name does not exist.

    $ more export_log.log A file or directory in the path name does not exist.


    NOTE: I was in the correct directory


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width