RMAN Open Database Tablespace Restore

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,

Michael42 Received on Sun Oct 30 2005 - 06:18:33 CST