OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » restore tables (10.2.0.2)

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

restore tables [message #364727]

Tue, 09 December 2008 16:42

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
I have one basic question.
Is there any way we can restore only two tables out of full backup taken by RMAN.
Regards,
Varun Punj,

Report message to a moderator

Re: restore tables [message #364736 is a reply to message #364727]

Tue, 09 December 2008 18:29

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You can not restore just a table with RMAN. You'd have to restore the backup to another location and export/import the table.

Report message to a moderator

Re: restore tables [message #364952 is a reply to message #364736]

Wed, 10 December 2008 10:20

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Ebrian,
By restoring backup at different location you mean :-

1,Copy the backup at different location.
2,Create the new database instance at new location.
3,Use RMAN restore command to get the data.

Regards,
Varun Punj

Report message to a moderator

Re: restore tables [message #364966 is a reply to message #364952]

Wed, 10 December 2008 12:26

ebrian
Messages: 2794
Registered: April 2006

Senior Member

1,Copy the backup at different location.
2,Create the new database instance at new location.
3,Restore/Recover database.
4,export table.
5,import table into original database.

Report message to a moderator

Previous Topic:	archivelogs older than retention policy don't delete
Next Topic:	Archivelog issue - minor but puzzeling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 02:40:52 CDT 2024