Home » RDBMS Server » Backup & Recovery » restore tables (10.2.0.2)
restore tables [message #364727] Tue, 09 December 2008 16:42 Go to next message
varunvir
Messages: 363
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,
Re: restore tables [message #364736 is a reply to message #364727] Tue, 09 December 2008 18:29 Go to previous messageGo to next message
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.
Re: restore tables [message #364952 is a reply to message #364736] Wed, 10 December 2008 10:20 Go to previous messageGo to next message
varunvir
Messages: 363
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
Re: restore tables [message #364966 is a reply to message #364952] Wed, 10 December 2008 12:26 Go to previous message
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.
Previous Topic: archivelogs older than retention policy don't delete
Next Topic: Archivelog issue - minor but puzzeling
Goto Forum:
  


Current Time: Tue Dec 06 02:36:08 CST 2016

Total time taken to generate the page: 0.18981 seconds