Home » RDBMS Server » Backup & Recovery » Recover Tablespace - RMAN (10.2.0.3, RHEL)
Recover Tablespace - RMAN [message #351557] Wed, 01 October 2008 09:09 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Recovery - NOARCHIVELOG
Next Topic: Full and Differential issue
Goto Forum:
  


Current Time: Fri Dec 02 18:57:13 CST 2016

Total time taken to generate the page: 0.19577 seconds