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


Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't.

Regards
Michel

Report message to a moderator

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....

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You just have to restore SYSTEM, SYSAUX and your tablespace.

Regards
Michel

Report message to a moderator

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 ?

Report message to a moderator

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

Report message to a moderator

Previous Topic: how see TIME (NOT DATE) when RMAN START?
Next Topic: RMAN restore/backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 12:38:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.