RMAN Open Database Tablespace Restore

From: "Michael42" <melliott42@xxxxxxxxx>
Date: 30 Oct 2005 04:18:33 -0800

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

.

Prev by Date: Re: Cannot locate Oracle Home after 10G installation. Getting ORA-12518
Next by Date: Re: Cannot locate Oracle Home after 10G installation. Getting ORA-12518
Previous by thread: Researcher: Oracle Passwords Crack in Mere Minutes: break the unbreakable?
Next by thread: Re: vmware + RAC 10g + windows
Index(es):
- Date
- Thread

Relevant Pages

Re: Rman Restore
... >I have a tablespace of 10 gb with 1 datafile. ... >Later I need this I restored it successfully from RMAN on a diff. ... >restore tablespace tbs; ... You did rename the datafile, didn't you, using the set newname ...
(comp.databases.oracle.server)
Rman Restore
... I have a tablespace of 10 gb with 1 datafile. ... Later I need this I restored it successfully from RMAN on a diff. ... restore tablespace tbs; ... The same command I am using next day but It is giving error. ...
(comp.databases.oracle.server)
Re: Incomplete Recovery of tablespace
... tablespace to a specified point in time. ... RMAN> alter database open resetlogs; ... not be the one from the backup but from the time of shutdown. ... the rman manual about TSPITR (tablespace point in time recovery). ...
(comp.databases.oracle.server)
Re: Recovery Manager (RMAN) problem
... will restore a database to its state in the past. ... I backup a TABLESPACE on which database stores user ... The problem is that changes made after I backup a tablespace ...
(comp.databases.oracle.server)
Re: Recovery Manager (RMAN) problem
... RMAN> SQL 'ALTER TABLESPACE USERS_CUSTOM OFFLINE'; ... RMAN> RESTORE TABLESPACE USERS_CUSTOM; ... USERS_CUSTOM from file rman_002.bus but database stores ...
(comp.databases.oracle.server)