Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    й
    Posts
    18

    Unanswered: who can tell me how to use dul?

    When I use dul to unload data from datafile, I got the follow error:


    DUL: Warning: Found mismatch while checking file /oradata/zyk/aaa.dbf
    DUL: Warning: DUL osd_parameter or control.dul configuration error
    DUL: Warning: Given file number(11) in control file does not match file# in dba(0)
    DUL: Warning: Found mismatch while checking file /oradata/zyk/aaa.dbf
    DUL: Warning: Start block: expected block number(8192) does not match block# in dba(209715
    2)
    11 /oradata/zyk/aaa.dbf startblock 8192 blocks 4186112 (off512=-131056)

    DUL> scan database;

    DUL: Error: block trailer mismatch 0X010B0000 != 0X00000B01
    DUL: Error: Wrong DBA 0X0100C002 (file=4, block=49154)
    DUL: Error: While processing block ts#=1073858704, file#=11, block#=8193
    DUL: Error: While processing block ts#=1073858704, file#=11, block#=8193


    how can I do?

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    You are using DUL on a datafile from a different machine, right?
    The block trailer is made up of the block SCN and sequence number.
    The block trailer mismatch looks like it has happened because it has been byte swapped, probably because you are trying to unload the database on a different platform than the one it was running on.

  3. #3
    Join Date
    Jan 2003
    Location
    й
    Posts
    18
    yeah, you are right, the datafile from windows 2000, and I use it on HP-UX, but how can I do now?

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    You can try setting OSD_BIG_ENDIAN_FLAG = FALSE in the dul init file.

    You may also need to change osd_file_leader_size

    Is this an Oracle7 database you are trying to unload?

Posting Permissions

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