Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN Open Database Tablespace Restore

RMAN Open Database Tablespace Restore

From: Michael42 <melliott42_at_yahoo.com>
Date: 30 Oct 2005 04:18:33 -0800
Message-ID: <1130674713.928731.83130@g43g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US