| Recover Tablespace - RMAN [message #351557] |
Wed, 01 October 2008 09:09  |
andydba
Messages: 34
Registered: September 2008
|
Member |
|
|
Hello,
One of the user in our organization dropped couple of tables. I have been asked to recover the tablespace that had these tables. I need to do TSPITR.
What is the best way to find out the LOGSEQ number or SCN point for TSPITR?
Thanks
-Andy
|
|
|
|
| Re: Recover Tablespace - RMAN [message #351561 is a reply to message #351557] |
Wed, 01 October 2008 09:35  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I would first ask several questions myself.
When did this happen?
How large are the tables?
Would flashback/recycle bin help?
By recovering the whole tablespace, you are you recovering all the tables. Is that ok?
If the requirement is to restore just a few tables,
I would restore selectively ( ignoring the unwanted tablespaces) to a test environment, see if i have data i need,
export the table and import into original table.
>>What is the best way to find out the LOGSEQ number or SCN point for TSPITR?
http://www.oracle-base.com/articles/9i/RecoveryManager9i.php
Though above article is meant for 9i, concepts are almost the same.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
