Home » RDBMS Server » Backup & Recovery » Recover Tablespace - RMAN (, RHEL)
Recover Tablespace - RMAN [message #351557] Wed, 01 October 2008 09:09 Go to next message
Messages: 34
Registered: September 2008


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?

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: 10673
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?

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 Jul 21 11:58:10 CDT 2017

Total time taken to generate the page: 0.09769 seconds