Home » RDBMS Server » Backup & Recovery » Table Recovery with RMAN.
Table Recovery with RMAN. [message #247453] Mon, 25 June 2007 23:22 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

With Datapump it is so much easy to recover just a simple table. But I have RMAN Backup. in that Backup I have a table with associated data. Forget about flashback feature. I dont want to restore the whole tablespace from RMAN backup. I just want to get a single table which one I had deleted after taking my RMAN backup. Is it possible?
Re: Table Recovery with RMAN. [message #247470 is a reply to message #247453] Tue, 26 June 2007 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN implies restore/recover of at least a small database: system, (sysaux,) undo and tablespace containing the table.
There is no "export table" function in RMAN.
RMAN only knows physical objects (database, tablespace, file, block) and not logical ones.

Regards
Michel
Re: Table Recovery with RMAN. [message #247631 is a reply to message #247470] Tue, 26 June 2007 10:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Forget about flashback feature. I dont want to restore the whole tablespace from RMAN backup. I just want to get a single table which one I had deleted after taking my RMAN backup. Is it possible?


may be we can expect that in coming and coming versions not in 10g ..11g..
Re: Table Recovery with RMAN. [message #247774 is a reply to message #247453] Wed, 27 June 2007 03:13 Go to previous messageGo to next message
pratik25
Messages: 4
Registered: June 2007
Location: HYDERABAD
Junior Member
what is your oracle version if you are using 9i then i think it is not possible becouse there is expor tipe command if you are using 10g then you can recover table from recyclebin of your tablespace

example in 10g
with following commond

flashback table <table_name> to before drop;

you can use Oracle Enterprise Manager 10g to recover a dropped table. You can query the USER_RECYCLEBIN or DBA_RECYCLEBIN view to identify the objects that have been dropped by you or all users.

You can use the SHOW RECYCLEBIN command to view the objects that can be undropped.

hope this help regard pratik
Re: Table Recovery with RMAN. [message #247776 is a reply to message #247453] Wed, 27 June 2007 03:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Pratik you are new member. Learn more .. Its the time to learn/post question not to post answer.
Re: Table Recovery with RMAN. [message #248350 is a reply to message #247453] Thu, 28 June 2007 13:10 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
@Arju
Are there any restrictions for junior members? When michel shifted to orafaq..he posted his first reply as a junior member(i am not comparing).I think the best way to learn is to reply..

Regards
yasir
Re: Table Recovery with RMAN. [message #248353 is a reply to message #248350] Thu, 28 June 2007 13:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I think the best way to learn is to reply...

I'd say even more: when you stop replying you begin to diminish your knowlegde.

Regards
Michel

[Updated on: Thu, 28 June 2007 13:20]

Report message to a moderator

Re: Table Recovery with RMAN. [message #248356 is a reply to message #247453] Thu, 28 June 2007 13:34 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
I'd say even more: when you stop replying you begin to diminish your knowlegde


You made me afraid Michel... Laughing
Re: Table Recovery with RMAN. [message #248561 is a reply to message #248350] Fri, 29 June 2007 09:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Pratik you are new member. Learn more .. Its the time to learn/post question not to post answer.

Unfortunately, it is just a number(count of posted messages) game here. A "junior member" or "senior member" does not mean anything technical here (except for the count of posts.).

Re: Table Recovery with RMAN. [message #249905 is a reply to message #247453] Fri, 06 July 2007 08:33 Go to previous messageGo to next message
Staale
Messages: 2
Registered: July 2007
Junior Member
I would say it is not possible.
You would have to restore into a new database, then do an export of the table you need, and then import this table into the original database.

Would probably also be possible to do a duplicate database with RMAN to a point-in-time before the drop, and then export/import.


Regards,
Staale
Re: Table Recovery with RMAN. [message #249912 is a reply to message #249905] Fri, 06 July 2007 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there any new in your post that is not in the previous ones?

Regards
Michel
Re: Table Recovery with RMAN. [message #249913 is a reply to message #249912] Fri, 06 July 2007 08:54 Go to previous messageGo to next message
Staale
Messages: 2
Registered: July 2007
Junior Member
Michel Cadot wrote on Fri, 06 July 2007 15:50
Is there any new in your post that is not in the previous ones?

Regards
Michel



Yeah..

I actually summed up what he needed to do.
The others used the flashback functionallity, which he explicitly stated he didnt't wanna know about.

But if you are representative of the common attitude on this board.. I take it I won't hang around either.. So you won't have to get any more posts from me.
Re: Table Recovery with RMAN. [message #249937 is a reply to message #249913] Fri, 06 July 2007 10:04 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Embarassed
Re: Table Recovery with RMAN. [message #249947 is a reply to message #249913] Fri, 06 July 2007 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bye.

Regards
Michel
Re: Table Recovery with RMAN. [message #249957 is a reply to message #249947] Fri, 06 July 2007 10:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
where you going cadot?
BED TIME Wink Laughing
Re: Table Recovery with RMAN. [message #249960 is a reply to message #249957] Fri, 06 July 2007 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Was an answer to Staale who said he is leaving the forum.

Btw, naming someone by his last name is offending in France. Call me either Michel or Michel Cadot or M. Cadot but not Cadot alone (and not putting the first letter in capital is the worst). ./fa/1579/0/

Regards
Michel
Re: Table Recovery with RMAN. [message #249964 is a reply to message #249960] Fri, 06 July 2007 11:05 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
okay alrite micheal. Embarassed

icon10.gif  Re: Table Recovery with RMAN. [message #250110 is a reply to message #249964] Sat, 07 July 2007 23:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

DreamzZ wrote on Fri, 06 July 2007 22:05
okay alrite micheal. Embarassed




It will be,
Michel .

Dream U made 2 mistakes..

1. Mistake in spelling.
2. First one will be capitalized.

Ha ha..

Be ok all.
Re: Table Recovery with RMAN. [message #250161 is a reply to message #250110] Sun, 08 July 2007 20:39 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Embarassed
thx for pointing Wink
Previous Topic: New Database Creation in another Host
Next Topic: Recovery after system crash
Goto Forum:
  


Current Time: Thu Dec 08 20:28:01 CST 2016

Total time taken to generate the page: 0.07120 seconds