OraFAQ Forum: Backup & Recovery » backup table using rman

Home » RDBMS Server » Backup & Recovery » backup table using rman

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

backup table using rman [message #318623]

Wed, 07 May 2008 06:08

mbhavin
Messages: 32
Registered: May 2008
Location: INDIA

Member

is it possible to backup only a single table and perform point in time recovery of that particular table

i am using oracle version 9.2.0.4

is it possible
please provide me with sufficient information

Report message to a moderator

Re: backup table using rman [message #318633 is a reply to message #318623]

Wed, 07 May 2008 06:30

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No it is not possible.
Use export to do that not rman.

Regards
Michel

Report message to a moderator

Re: backup table using rman [message #318635 is a reply to message #318633]

Wed, 07 May 2008 06:35

mbhavin
Messages: 32
Registered: May 2008
Location: INDIA

Member

thank you but can u please elaborate more on how export and rman both can be co-ordinated together

Report message to a moderator

Re: backup table using rman [message #318651 is a reply to message #318635]

Wed, 07 May 2008 08:14

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

They can't be coordinate.

RMAN is PHYSICAL backup
EXP is LOGICAL backup

No relation.

Regards
Michel

Report message to a moderator

Re: backup table using rman [message #319759 is a reply to message #318651]

Tue, 13 May 2008 00:03

mbhavin
Messages: 32
Registered: May 2008
Location: INDIA

Member

THanks for clearing my concept thanks a lot

Report message to a moderator

Previous Topic:	target db not open after create AUXiliary instance (merged 3)
Next Topic:	datafile loss and not any backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 12:06:16 CDT 2024