OraFAQ Forum: Backup & Recovery » backup and restore tablespace

Home » RDBMS Server » Backup & Recovery » backup and restore tablespace (window 2008 , oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup and restore tablespace [message #637217]

Wed, 13 May 2015 03:55

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

hi,

I need to backup tablespace DD900 from database Server A, Instance name: A1, and restore to Server B, Instance name : B1. can you give me information how to restore it ? I using RMAN.

I backup using :
RMAN > backup tablespace dd900 plus archivelog;

Report message to a moderator

Re: backup and restore tablespace [message #637219 is a reply to message #637217]

Wed, 13 May 2015 04:28

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You cannot do that with RMAN only.
You have to use Data Pump transportable tablespace.

[Updated on: Fri, 15 May 2015 08:23]

Report message to a moderator

Re: backup and restore tablespace [message #637221 is a reply to message #637219]

Wed, 13 May 2015 04:33

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

hi Michel,
So I need using dump file ( expdp ) and that is take long times because our database is bigger. can I use other ?

Report message to a moderator

Re: backup and restore tablespace [message #637222 is a reply to message #637221]

Wed, 13 May 2015 04:53

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No, it should not take long if you use TRANSPORTABLE_TABLESPACE option.
Please read the documentation about that feature.

Report message to a moderator

Re: backup and restore tablespace [message #637223 is a reply to message #637222]

Wed, 13 May 2015 05:13

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

hi michel,
how to use it ( TRANSPORTABLE_TABLESPACE) ? and please share if you had document.

Report message to a moderator

Re: backup and restore tablespace [message #637224 is a reply to message #637223]

Wed, 13 May 2015 05:25

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All documentation is available at http://docs.oracle.com

Report message to a moderator

Re: backup and restore tablespace [message #637225 is a reply to message #637224]

Wed, 13 May 2015 05:30

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

hi michel,
thank you for your advice. and I found : https://www.youtube.com/watch?v=YG6kWX7Par8.

and thank you very much. and please close this case.

Report message to a moderator

Re: backup and restore tablespace [message #637226 is a reply to message #637225]

Wed, 13 May 2015 05:54

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thank you for your feedback and for the link.

Report message to a moderator

Re: backup and restore tablespace [message #637227 is a reply to message #637226]

Wed, 13 May 2015 06:06

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

hi michel,
I had last question, I need restore incremental that is can using : TRANSPORTABLE_TABLESPACE ? example today, I had restore table "A" only 340 records, and tomorrow I want to restore incremental table "A" : 390 records ( 390 - 340 = 50 records). that is possible to using : TRANSPORTABLE_TABLESPACE ?

Report message to a moderator

Re: backup and restore tablespace [message #637228 is a reply to message #637227]

Wed, 13 May 2015 06:15

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

TABLESPACE <> TABLE.

So it depends on your case.
If there is only one table in the tablespace and the table does not depends on anything in the other tablespace then you can use TRANSPORTABLE TABLESPACE but, afaik, you can't do it incrementally, you have to get the whole table.

If you have only one table you should use a materialized view, Streams or logical standby to duplicate in your second db (which assumes you have a network between the 2)?

Report message to a moderator

Re: backup and restore tablespace [message #637230 is a reply to message #637228]

Wed, 13 May 2015 06:17

alimlim
Messages: 8
Registered: May 2015
Location: indonesia

Junior Member

michel,
ok. thank you very much for your advice.

Report message to a moderator

Previous Topic:	ORA-16038: log 2 sequence# 284 cannot be archived
Next Topic:	RMAN-04004: error fro recovery catalog database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 02 06:41:42 CDT 2023