| recover a single table from backup [message #440211] |
Thu, 21 January 2010 11:24  |
Richard2009
Messages: 21
Registered: October 2009
Location: London
|
Junior Member |
|
|
Hi Experts,
What's the best way to recover a single table from the backup? Which tool is recommended for this in Oracle 10g/11g? Please share your experience/knowledge on this.
Regards,
Richard
|
|
|
|
|
|
| Re: recover a single table from backup [message #440222 is a reply to message #440211] |
Thu, 21 January 2010 12:45  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
You can't recover one table from a backup! The rules of a relational database forbid it, because to do so would compromise the transactional integrity. You can try to replace it with a copy taken from an export, or you can try to back-out changes with undo-based flashback, but there is no guarantee that these will work.
|
|
|
|
 Re: recover a single table from backup [message #440225 is a reply to message #440211] |
Thu, 21 January 2010 12:58 |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
A) If you have export backup, then you can import the table.
B) If you have rman backup or OS cold/hot backup you would need to restore to another server/database, export the table and import to you db.
WARNING: You will only have the table data until the time the backup was taken plus (except for export backup) any archive logs you could apply .
PS: Have you checked the RECYCLEBIN? Maybe i's still there...
[Updated on: Thu, 21 January 2010 13:12] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: recover a single table from backup [message #440288 is a reply to message #440287] |
Fri, 22 January 2010 01:06 |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Michel Cadot wrote on Fri, 22 January 2010 12:29
OK, so what do you think the following answer:
"You don't need to recover the table is still there."
I am Unable to find the quoted(BOLD) one here in this Question...Can you show me where/when/who posted that..Please..
sriram 
[Updated on: Fri, 22 January 2010 01:07] Report message to a moderator |
|
|
|
| Re: recover a single table from backup [message #440290 is a reply to message #440288] |
Fri, 22 January 2010 01:11 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
I post that now just to show you that your sentence just leads to silly answer and we currently get more and more of this kind of answer because posters assume some things they have not to assume but should ask OP for precisions if they think the question lacks of them.
Regards
Michel
[Updated on: Fri, 22 January 2010 01:14] Report message to a moderator |
|
|
|
|
|
 Re: recover a single table from backup [message #440324 is a reply to message #440290] |
Fri, 22 January 2010 07:18 |
|
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Due to the fact the the only information provided by the OP is "recover a single table" and the two possibilities in which this may occur are: a) Table data was corrupted by bad DML or b) Table was dropped, It is valid to provide answers based on assumptions that any of these two situation may have occured.
And I agree with ramoradba in the sense that if the answers do not satisfy the OP, then he/she should provide more specific details or explanation.
[Updated on: Fri, 22 January 2010 08:13] by Moderator Report message to a moderator |
|
|
|
|
|
 Re: recover a single table from backup [message #440327 is a reply to message #440325] |
Fri, 22 January 2010 07:45 |
|
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Hi sriram,
I don't know why you beleive I was critisizing anyone, but if someone took offense it was unintentional.
If you are refering to my "PS" to michel, just a joke, he dislikes the use of smilies and seems to enjoy removing them from postings.
On the issue of this thread, if we can cover any angle related to a question, why not? sometimes the information posted will provide ideas to the OP and help him/her focus on the actual issue trying to be solved.
Well, maybe we should shut down this thread and move on.
(TGIF) Have a great weekend!
PS: Where do you get those nice smilies that don't appear on the edit window?
[Updated on: Fri, 22 January 2010 07:46] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
