Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle corrupted files

smeeJul 24 2013 — edited Jul 24 2013

Hi,

I have questions about recreating Oracle users/Oracle database and corrupted data files.

Let me explain. I use Oracle 10.2.0.5.0 server and had problem with a few corrupted data blocks. With DBMS_REPAIR package I manage to isolate those blocks and to continue with normally work. But I wonder if I take backup of this database and create dump file (I will use traditional exp Oracle tool to accomplish this) , drop Oracle users, recreate them and then import earlier mentioned dump file will database files still contain those bad sectors? Or is better for me to recreate whole database?

Thanks in advance,

smee

This post has been answered by Stefan Koehler on Jul 24 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 21 2013

Added on Jul 24 2013

#file, #general-database-discussions, #oracle, #user

4 comments

728 views