Solved

Use of DBMS_REPAIR in oracle 10.2.0.4

Posted on 2011-09-09
2
396 Views
Last Modified: 2012-05-12
Hi experts,

 I am experiencing a problem with a table that has corrupted blocks. The dbms_repair tool in oracle 8i and 9i was only marking the corrupted blocks and skipping them. That is not good for me in this situation. I heard that in oracle 11i it does much more. But my question is does it do more in oracle 10i also? Can someone telle me what the dbms_repair does in oracle 10i.
0
Comment
Question by:sharscho
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36510237
I would always start in the docs:
Using DBMS_REPAIR to Repair Data Block Corruption

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm#ADMIN022
0
 

Author Closing Comment

by:sharscho
ID: 36519649
I expected some advices from experts who had used this before and had experience with it. I had the link myself. Thanks anyways.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question