Validation export dump files

[roukie_dba]

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???

[dvc]

I way is to import it using read only parameter.

[roukie_dba]

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?

[ATHER]

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.

[sambavan]

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

[roukie_dba]

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.