recover tablespace until

[patrick118]

I'm testing a few things with recovery.

I have a database 9.2 in archivelog mode.

I made a cold backup of the entire database

started the database and made some changes to the table in tablespace example.
scn is now 55770
made some more changes and scn is now 55980
I set the tablespace offline
deleted the datafile from the tablespace example
copied back the datafile from my backup.
This is out of sync.
If i would do the following
recover tablespace example;
it would be working
But i don't want that i want to go back to scn 55770
so i thought the following
recover tablespace example until scn 55770
but i get an error
ORA-00274 illegal recovery option until

How should i be approaching this? I do not want to put the entire database back to scn 55770 just the example tablespace.

 

[karluk]

Unfortunately, Oracle won't allow you to recover a single tablespace to a point in time or to a specific SCN. Doing so would put the tablespace out of sync with all the other tablespaces in the database. If you really need to get the data in this tablespace back to a prior SCN, you will most likely need to clone your database to another location, recover the clone to the SCN you want, export the data you want from the clone, and then import it into the live database.

You should also investigate using flashback queries to recover data in a single table.

 

[patrick118]

I allready thought that would be the answer i get.

Thank you for answering.

Well back to the studybooks and look at TSPITR

 

[Thargy]

Patrick,

even using RMAN a TSPITR (tablespace point in time recovery) is not for the faint hearted. The book says it's quite a tough cookie, so kudos to you for tackling it alone.

Regards

T

Grinding away at things Oracular