View previous topic :: View next topic
|
Author |
Message |
Jeevankumar.Pochammala
New User
Joined: 04 May 2011 Posts: 7 Location: INDIA
|
|
|
|
Hello All,
In one of my Application table some pages got corrupted and i tried to repair it by using Repair utility but still pages not freed from Corruption.
So can any one please let me know how recover the data from these corrupted pages. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
How did these "pages" get corrupted?
Suggest you restore the table from the current backup.
Your best source of help is probably your dba. . . |
|
Back to top |
|
|
Jeevankumar.Pochammala
New User
Joined: 04 May 2011 Posts: 7 Location: INDIA
|
|
|
|
Hello d.sch,
I had checked with DBA he tried to restore the data from Backup but still it is not recovering.
Please let me know if you have any other solutions
Thanks for your reply
Thanks
Jeevan |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Seems a silly question, but have you tried an older backup? Maybe the "corruption" happened before the latest backup? In general, backup/restore puts things back a treat, that's why we do them - but the backup has to have "good" data on for you to restore to a "good" position for you.
What about Dick's question?
What are the symptoms (error messages) of the "corruption". Did you get any messages out of your repair attempt?
Basically, the more information about your problem that you can post, the better chance you have of a fix emerging. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Were the backups ever tested to be correct/useful prior to now? If not, your environment is in serious trouble. . . Backups that have never been successfully restored are NOT backups - they are merely some media with questionable content. . .
Quote: |
I had checked with DBA he tried to restore the data from Backup but still it is not recovering. |
All this is is a longer way to say "it didn't work". What is probably the most useless thing to post is "it didn't work". This provides nothing than can be used to help you.
When something doesn't work, there are footprints (an abend, an error message, etc). You need to post the diagnostic information that was generated.
Is there possibly an image copy of the data? If there is, the data might be unloaded and re-loaded into the table.
If the table has been further damaged by people since the original problem, you may need to simply drop the table and re-create it. |
|
Back to top |
|
|
|