Home » RDBMS Server » Backup & Recovery » backup and restore tablespace (window 2008 , oracle 11g)
backup and restore tablespace [message #637217] Wed, 13 May 2015 03:55 Go to next message
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;
Re: backup and restore tablespace [message #637219 is a reply to message #637217] Wed, 13 May 2015 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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 Go to previous messageGo to next message
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 ?
Re: backup and restore tablespace [message #637222 is a reply to message #637221] Wed, 13 May 2015 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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.

Re: backup and restore tablespace [message #637223 is a reply to message #637222] Wed, 13 May 2015 05:13 Go to previous messageGo to next message
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.
Re: backup and restore tablespace [message #637224 is a reply to message #637223] Wed, 13 May 2015 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: backup and restore tablespace [message #637225 is a reply to message #637224] Wed, 13 May 2015 05:30 Go to previous messageGo to next message
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.
Re: backup and restore tablespace [message #637226 is a reply to message #637225] Wed, 13 May 2015 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thank you for your feedback and for the link.

Re: backup and restore tablespace [message #637227 is a reply to message #637226] Wed, 13 May 2015 06:06 Go to previous messageGo to next message
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 ?
Re: backup and restore tablespace [message #637228 is a reply to message #637227] Wed, 13 May 2015 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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)?

Re: backup and restore tablespace [message #637230 is a reply to message #637228] Wed, 13 May 2015 06:17 Go to previous message
alimlim
Messages: 8
Registered: May 2015
Location: indonesia
Junior Member
michel,
ok. thank you very much for your advice.
Previous Topic: ORA-16038: log 2 sequence# 284 cannot be archived
Next Topic: RMAN-04004: error fro recovery catalog database
Goto Forum:
  


Current Time: Thu Mar 28 07:16:13 CDT 2024