Home » RDBMS Server » Backup & Recovery » recover a single table from backup (Oracle 10g/11g)
recover a single table from backup [message #440211] Thu, 21 January 2010 11:24 Go to next message
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 #440212 is a reply to message #440211] Thu, 21 January 2010 11:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What's the best way to recover a single table from the backup?
It depends upon what/how backup was taken.
If RMAN backup, then RMAN restore.
Re: recover a single table from backup [message #440222 is a reply to message #440211] Thu, 21 January 2010 12:45 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
icon12.gif  Re: recover a single table from backup [message #440225 is a reply to message #440211] Thu, 21 January 2010 12:58 Go to previous messageGo to next message
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 #440233 is a reply to message #440225] Thu, 21 January 2010 13:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
PS: Have you checked the RECYCLEBIN? Maybe i's still there...

Who said the table has been lost? Who said it has been dropped?
The question is:

Quote:
A) If you have export backup, then you can import the table.

An import is not a recovery.

Regards
Michel
Re: recover a single table from backup [message #440259 is a reply to message #440233] Thu, 21 January 2010 21:29 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Here i agree with Blackswan...
IF it is through RMAN Please Check the Below links
how-to-recover-a-table-using-rman-backup

recovering-a-particular-table

And IF we don`t have the complete information ,
1)We can ask the OP for more specific details...
2)) We can post/send Our replies/suggestions/thoughts BY assuming any of the possible reasons.is n`t it?


sriram Smile
Re: recover a single table from backup [message #440278 is a reply to message #440259] Fri, 22 January 2010 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
2)) We can post/send Our replies/suggestions/thoughts BY assuming any of the possible reasons.is n`t it

We can say that it is out of topic, isn't it?

Regards
Michel
Re: recover a single table from backup [message #440284 is a reply to message #440278] Fri, 22 January 2010 00:45 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Michel Cadot wrote on Fri, 22 January 2010 11:31
We can say that it is out of topic, isn't it?

Regards
Michel



NO it`s Not...As per your Message..TO Lk_BRWN_DBA

He said his openion the OP has to decide/post if his post correct or not thats It!

And whatever i stated in My previous post are Just for you.

sriram Smile

[Updated on: Fri, 22 January 2010 00:46]

Report message to a moderator

Re: recover a single table from backup [message #440287 is a reply to message #440284] Fri, 22 January 2010 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
He said his openion the OP has to decide/post if his post correct or not thats It!

OK, so what do you think the following answer:
"You don't need to recover the table is still there."
As per your post ("We can post/send Our replies/suggestions/thoughts BY assuming any of the possible reasons") it is a valid answer, but just a silly one given original question.

Regards
Michel
Re: recover a single table from backup [message #440288 is a reply to message #440287] Fri, 22 January 2010 01:06 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Smile

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 #440291 is a reply to message #440290] Fri, 22 January 2010 01:16 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
THank you

sriram Smile
icon10.gif  Re: recover a single table from backup [message #440324 is a reply to message #440290] Fri, 22 January 2010 07:18 Go to previous messageGo to next message
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 #440325 is a reply to message #440324] Fri, 22 January 2010 07:26 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
NO Now i totally disagree with you...

It is a best approach to ask the OP.

And i prefer "Don`t criticise any User" /forum/fa/1579/0/
If you re read the discussion between Michel and Me i hope you may realise . And seniors are here to Guide Us,Answers/post with the assumptions may miss lead the OP.

Thank you
sriram Smile
icon6.gif  Re: recover a single table from backup [message #440327 is a reply to message #440325] Fri, 22 January 2010 07:45 Go to previous messageGo to next message
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?
Smile

[Updated on: Fri, 22 January 2010 07:46]

Report message to a moderator

Re: recover a single table from backup [message #441155 is a reply to message #440327] Fri, 29 January 2010 01:50 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
LKBrwn_DBA wrote on Fri, 22 January 2010 19:15
Hi sriram,
PS: Where do you get those nice smilies that don't appear on the edit window?
Smile


from "Test" forum "smiley gallery" Wink

here

sriram Smile

[Updated on: Fri, 29 January 2010 01:56]

Report message to a moderator

Previous Topic: Database up to date
Next Topic: Restore from backup
Goto Forum:
  


Current Time: Thu Mar 28 16:21:45 CDT 2024