AIX

@hicksd8
The Database or Datafile is not corrupt (see here -- posted on Oracle Forums)

Code:

SQL> select * from v$database_block_corruption ;
 
 
no rows selected
 
 
SQL>

This is what I am thinking, export all data from applsysd02.dbf to temporary.dbf
delete applsysd02.dbf
create applsysd02.dbf in another filesystem
import data into applsysd02.dbf from temporary.dbf

But I am not sure, if this will work for Oracle Database as applsysd02.dbf contains Apps Top Tier information, so what I wanted is confirmation from DBA -- hence posted on Oracle forums.

May be someone here knows if this works :-)

Sorry to say that, but this might not be the case. Maybe the database just isn't aware of the corrupted blocks.

No, no: an "export" is the dumping of the DBs (not only a single DB files) contents to a (human-readable) file, basically an ASCII-file. This will dump *all* the contents: table content, constraints, views, dependencies, and what else there is in the DB and cannot be created (like indices). From such a file you rebuild the complete DB by importing it into an empty container.

Does that answer your question?

I hope this helps.

bakunin

Thanks Bakunin, I guess there is nothing that could be done at this point.