Home » Server Options » Data Guard » Is Data Guard running except transfer TEMP Tablespace? (Windows 2003EE, Oracle 10g R2, RAC)
Is Data Guard running except transfer TEMP Tablespace? [message #286828] Mon, 10 December 2007 03:20 Go to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

HI all

We are using Oracle10g R2 and Data Guard for transfer data from Primary to Standby.
Is there any possible transfer data except TEMP tablespace?

Best Regards
Re: Is Data Guard running except transfer TEMP Tablespace? [message #286885 is a reply to message #286828] Mon, 10 December 2007 06:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Data guard is not for data transfer.
you can use DATAPUMP(EXPORT/IMPORT) utility, SQL*LOADER.

Re: Is Data Guard running except transfer TEMP Tablespace? [message #286901 is a reply to message #286828] Mon, 10 December 2007 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far as I know, there is no data regarding TEMP tablespace transfered between primary and standby database as temporary data are useless to recover a database.

Regards
Michel
Re: Is Data Guard running except transfer TEMP Tablespace? [message #286909 is a reply to message #286901] Mon, 10 December 2007 07:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

But Micheal, OP don't want to transfer TEMP tablespace he want except temp tablespace is there any way to transfer data from primary to standby database.

Re: Is Data Guard running except transfer TEMP Tablespace? [message #286913 is a reply to message #286909] Mon, 10 December 2007 07:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what I meant: there is nothing to do, data from all tablespaces are transfered except temp tablespace.
"Transfer" means here change vectors are forwarded and applied to standbyand not that data are directly forwarded.

Regards
Michel
Re: Is Data Guard running except transfer TEMP Tablespace? [message #286921 is a reply to message #286913] Mon, 10 December 2007 07:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank you for Clarification.
Re: Is Data Guard running except transfer TEMP Tablespace? [message #287304 is a reply to message #286921] Tue, 11 December 2007 22:04 Go to previous message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

Thanks all.
Previous Topic: standby/hot standby?
Next Topic: Run an EXPORT against a standby database.
Goto Forum:
  


Current Time: Tue Dec 06 11:58:43 CST 2016

Total time taken to generate the page: 0.10435 seconds