Home » RDBMS Server » Backup & Recovery » RMAN How to restore a single tablespace into a different host (10.1 and older ( Solaris ))
RMAN How to restore a single tablespace into a different host [message #359600] Mon, 17 November 2008 09:56 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I am looking for a way to use RMAN to restore one tablespace into a
DIFFERENT database/host.
I know I can use RMAN transportable tablespace starting from 10.2
( and I have used it successfully ) , but I have a database operating
on 10.1 as well as a 9i databases.


How can this be accomplished without having to restore the entire
database ?


thanks!
Orna


Re: RMAN How to restore a single tablespace into a different host [message #359605 is a reply to message #359600] Mon, 17 November 2008 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: RMAN How to restore a single tablespace into a different host [message #359606 is a reply to message #359600] Mon, 17 November 2008 10:12 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
wow

that is very disappointing
So - in order to restore one table in one small tablespace I will need to restore my entire 10 TB of database....
Re: RMAN How to restore a single tablespace into a different host [message #359613 is a reply to message #359606] Mon, 17 November 2008 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You just have to restore SYSTEM, SYSAUX and your tablespace.

Regards
Michel
Re: RMAN How to restore a single tablespace into a different host [message #359615 is a reply to message #359613] Mon, 17 November 2008 10:54 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Oh, that is better Smile

So what is the procedure exactly ?
can you point me to a documentation link or some other source that can guide me thru it ?
Re: RMAN How to restore a single tablespace into a different host [message #359617 is a reply to message #359615] Mon, 17 November 2008 11:18 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
ok, found a good source
basically - you use the duplicate database with skip tablespaces option

http://cursos.atica.um.es/DBA10g1/anexos/RMAN/Nota_223543.1_RMAN_RECUPERAR%20TABLAS.pdf
Previous Topic: how see TIME (NOT DATE) when RMAN START?
Next Topic: RMAN restore/backup
Goto Forum:
  


Current Time: Wed Dec 07 03:10:22 CST 2016

Total time taken to generate the page: 0.14073 seconds