Hello,

In Oracle 9i using RMAN I have heard that there may be some instances
where you cannot perform an online tablespace restore. When would this
be the case?

Below is how I do online TS restores.

1. sqlplus "/ as sysdba"
2. SQL> alter tablespace users offline;
3. rman target / nocatalog
4. RMAN> restore tablespace users;
5. RMAN> recover tablespace users;
6. SQL> alter tablespace users online;

Thanks,

Effie

Oracle LazyDBA home page