restore tables [message #364727] |
Tue, 09 December 2008 16:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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,
|
|
|
|
Re: restore tables [message #364952 is a reply to message #364736] |
Wed, 10 December 2008 10:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
Re: restore tables [message #364966 is a reply to message #364952] |
Wed, 10 December 2008 12:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/85219.jpg) |
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.
|
|
|