SEO

#1 (**permalink**) 02-24-2008, 05:23 PM

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

#2 (**permalink**) 02-24-2008, 05:23 PM

Point in time and SYSTEM tablespace recovery are two cases that I can not
imagine a simple tablespace recovery with DB online. You may want to look
through the Oracle9i RMAN Users Guide for more.

Hope you realize that you do not need to acces SQLPLUS. RMAN includes the
SQL command so you could simplify to

1. rman target / nocatalog
2. RMAN> sql 'alter tablespace users offline';
3. RMAN> restore tablespace users;
4. RMAN> recover tablespace users;
5. RMAN> sql 'alter tablespace users online';

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

RMAN Open Database Tablespace Restore