Rman: restoreing tablespace

[kumar.j...@gmail.com]

using rman iam takeing backup of database plus archivelog. now i
remove at os level & sql level one tablespace using drop tablespace
ts_name including contents and datafiles. now i want retrive the
tablespace by using rman. how to resolve the problem..... If i say
restore tablespace ts_name it was showing the standard input
error..... then how to recollect datafile and tablespace.....

kindly help me .................

[sampath]

Kumar

In this scenario you willl have to perform point-in-time recovery
(incomplete) till the time the tablespace was dropped. But the changes
made after the tablespace dropped will be lost.

After perfroming recovery you need reset the logs.




Sampath Kumar Bodiga.




On Jun 11, 7:05 am, "kumar.janid...@gmail.com"