OraFAQ Forum: Backup & Recovery » Table Recovery with RMAN.

Home » RDBMS Server » Backup & Recovery » Table Recovery with RMAN.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table Recovery with RMAN. [message #247453]

Mon, 25 June 2007 23:22

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?

Report message to a moderator

Re: Table Recovery with RMAN. [message #247470 is a reply to message #247453]

Tue, 26 June 2007 01:04

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Table Recovery with RMAN. [message #247631 is a reply to message #247470]

Tue, 26 June 2007 10:56

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..

Report message to a moderator

Re: Table Recovery with RMAN. [message #247774 is a reply to message #247453]

Wed, 27 June 2007 03:13

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

Report message to a moderator

Re: Table Recovery with RMAN. [message #247776 is a reply to message #247453]

Wed, 27 June 2007 03:41

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.

Report message to a moderator

Re: Table Recovery with RMAN. [message #248350 is a reply to message #247453]

Thu, 28 June 2007 13:10

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

Report message to a moderator

Re: Table Recovery with RMAN. [message #248353 is a reply to message #248350]

Thu, 28 June 2007 13:20

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Laughing

Report message to a moderator

Re: Table Recovery with RMAN. [message #248561 is a reply to message #248350]

Fri, 29 June 2007 09:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

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.).

Report message to a moderator

Re: Table Recovery with RMAN. [message #249905 is a reply to message #247453]

Fri, 06 July 2007 08:33

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

Report message to a moderator

Re: Table Recovery with RMAN. [message #249912 is a reply to message #249905]

Fri, 06 July 2007 08:50

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is there any new in your post that is not in the previous ones?

Regards
Michel

Report message to a moderator

Re: Table Recovery with RMAN. [message #249913 is a reply to message #249912]

Fri, 06 July 2007 08:54

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.

Report message to a moderator

Re: Table Recovery with RMAN. [message #249937 is a reply to message #249913]

Fri, 06 July 2007 10:04

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Embarassed

Report message to a moderator

Re: Table Recovery with RMAN. [message #249947 is a reply to message #249913]

Fri, 06 July 2007 10:30

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Bye.

Regards
Michel

Report message to a moderator

Re: Table Recovery with RMAN. [message #249957 is a reply to message #249947]

Fri, 06 July 2007 10:45

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

where you going cadot?
BED TIME Wink

Wink

Laughing

Report message to a moderator

Re: Table Recovery with RMAN. [message #249960 is a reply to message #249957]

Fri, 06 July 2007 10:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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). /forum/fa/1579/0/

/forum/fa/1579/0/

Regards
Michel

Report message to a moderator

Re: Table Recovery with RMAN. [message #249964 is a reply to message #249960]

Fri, 06 July 2007 11:05

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

okay alrite micheal. Embarassed

Embarassed

Report message to a moderator

Re: Table Recovery with RMAN. [message #250110 is a reply to message #249964]

Sat, 07 July 2007 23:41

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

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.

Report message to a moderator

Re: Table Recovery with RMAN. [message #250161 is a reply to message #250110]

Sun, 08 July 2007 20:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Embarassed

thx for pointing Wink

Wink

Report message to a moderator

Previous Topic:	New Database Creation in another Host
Next Topic:	Recovery after system crash

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 10:07:41 CDT 2025