Validation export dump files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Validation export dump files

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear members
    Can someone tell me a way of validating an export dump file? How can I make sure I can recover my entire database from the dump file of a full export???
    roukie-dba

  2. #2
    Join Date
    Jul 2001
    Posts
    45
    I way is to import it using read only parameter.

  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    Moderators please comment

    Can the moderators please comment on my question? How can I check that my export dump is valid without having to do a full import of the data?
    roukie-dba

  4. #4
    Join Date
    Mar 2001
    Posts
    20
    imp username/password@conn_string file=filename show=y

    This will show you all the contents of the export file without importing, you can spool the results and verify all the objects are present or not.

    As per as validating export file data, I don't think it is possible.

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is a script that would do the check and make sure that the export and imports were successfull...

    This gives schema wise total object count, valid object count and invalid object count ...
    ------------------------cut here-------------------------------------
    set linesize 80
    set pagesize 80

    spool repobjcount.lst

    ttitle ' ' skip 2 -
    center 'ORACLE RDBMS' skip 1 -
    center 'Object Count Report' right 'Page:' format 99 sql.pno skip 2

    col owner format a16 heading 'Object Owner'
    col object_type format a20 heading 'Object Type'
    col count(*) format 9999 heading 'Object|Count'

    break on owner
    compute sum of count(*) on owner skip 1

    select owner,object_type, count(*)
    from dba_objects
    group by owner,object_type;

    ttitle ' ' skip 2 -
    center 'ORACLE RDBMS' skip 1 -
    center 'Valid Object Count Report' right 'Page:' format 99 sql.pno skip 2

    break on owner
    compute sum of count(*) on owner skip 1

    select owner,object_type, count(*)
    from dba_objects
    where status = 'VALID'
    -- where status = 'INVALID'
    group by owner,object_type;

    ttitle ' ' skip 2 -
    center 'ORACLE RDBMS' skip 1 -
    center 'Invalid Object Count Report' right 'Page:' format 99 sql.pno skip 2


    break on owner
    compute sum of count(*) on owner skip 1

    select owner,object_type, count(*)
    from dba_objects
    where status = 'INVALID'
    group by owner,object_type;

    spool off

    clear columns
    clear breaks
    --set feedback on
    set verify on
    ------------------------cut here-------------------------------------


    Curtesy to the poster who ever had posted this script earlier..

    In the mean time, you also could write a script that would scan your logfile and report of any problems in the export. The following link would provide you with the list on export errors, that you can make use of...

    http://www.oradoc.com/ora816/server....expus.htm#1656


    Hope this anwers your question, BTW, what ATHER suggested was also a most appropriate way one should do before an import.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Ather and Sam
    Thanks very much, I tried both methods and they both work great. I will now use both since they do complement each other.
    Thanks again.
    roukie-dba

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