Subject: Re: Is Data Guard running except transfer TEMP Tablespace?
From: Carel-Jan Engel <careljan@dbalert.eu>
To: enkhbold@khanbank.com
Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
In-Reply-To: <006f01c83c6d$4f38bf40$edaa3dc0$@com>
References:   <006f01c83c6d$4f38bf40$edaa3dc0$@com>
Content-Type: multipart/alternative; boundary="=-taI5xeCK8vbkNHb7KVDn"
Date: Wed, 12 Dec 2007 09:35:29 +0100
Message-Id: <1197448529.12250.57.camel@lagavulin.dbalert.eu>
Mime-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: careljan@dbalert.eu
--=-taI5xeCK8vbkNHb7KVDn
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Read the concepts and administration guide of Data Guard
Read the concepts guide of Oracle 10g.

Data Guard doesn't sent 'data'. It sends redo.

Writing in TEMP doesn't generate redo. Writing to temporary tables will
generate UNDO though, and UNDO is logged, and sent to the standby. Tom
Kyte explains this in his book Expert Oracle Database Architecture, from
p. 319 onwards.


Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

On Wed, 2007-12-12 at 11:15 +0800, Enkhbold Dashdondog wrote:
> HI all 
> 
>  
> 
> We are using Oracle10g R2 and Data Guard for transfer data from
> Primary to Standby. 
> 
> Data Guard transfer data from Primary to Standby if anything is
> changed. 
> 
> Is there any possible is Can Data Guard transfer data except TEMP
> tablespace? 
> 
> Because of, for some processing we using temp tables in TEMP
> tablespace, it is not need to update Standby database. 
> 
>  
> 
> Best Regards 
> 
>  
> 
> 
> 
> 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner, and is 
> believed to be clean.


--=-taI5xeCK8vbkNHb7KVDn
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.6.1">
</HEAD>
<BODY LINK="#0000ff">
Read the concepts and administration guide of Data Guard<BR>
Read the concepts guide of Oracle 10g.<BR>
<BR>
Data Guard doesn't sent 'data'. It sends redo.<BR>
<BR>
Writing in TEMP doesn't generate redo. Writing to temporary tables will generate UNDO though, and UNDO is logged, and sent to the standby. Tom Kyte explains this in his book Expert Oracle Database Architecture, from p. 319 onwards.<BR>
<BR>
<BR>
Best regards,<BR>
<BR>
Carel-Jan Engel<BR>
<BR>
===<BR>
If you think education is expensive, try ignorance. (Derek Bok)<BR>
===<BR>
<BR>
On Wed, 2007-12-12 at 11:15 +0800, Enkhbold Dashdondog wrote:
<BLOCKQUOTE TYPE=CITE>
    <FONT COLOR="#000000">HI all </FONT><BR>
    <BR>
    <FONT COLOR="#000000">&nbsp;</FONT><BR>
    <BR>
    <FONT COLOR="#000000">We are using Oracle10g R2 and Data Guard for transfer data from Primary to Standby. </FONT><BR>
    <BR>
    <FONT COLOR="#000000">Data Guard transfer data from Primary to Standby if anything is changed. </FONT><BR>
    <BR>
    <FONT COLOR="#000000">Is there any possible is Can Data Guard transfer data except TEMP tablespace? </FONT><BR>
    <BR>
    <FONT COLOR="#000000">Because of, for some processing we using temp tables in TEMP tablespace, it is not need to update Standby database. </FONT><BR>
    <BR>
    <FONT COLOR="#000000">&nbsp;</FONT><BR>
    <BR>
    <FONT COLOR="#000000">Best Regards </FONT><BR>
    <BR>
    <FONT COLOR="#000000">&nbsp;</FONT><BR>
    <BR>
    <BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
    <BR>
    <FONT COLOR="#000000">-- </FONT><BR>
    <FONT COLOR="#000000">This message has been scanned for viruses and </FONT><BR>
    <FONT COLOR="#000000">dangerous content by </FONT><FONT COLOR="#000000"><B><A HREF="http://www.mailscanner.info/">MailScanner</A></B></FONT><FONT COLOR="#000000">, and is </FONT><BR>
    <FONT COLOR="#000000">believed to be clean.</FONT><BR>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-taI5xeCK8vbkNHb7KVDn--

--
http://www.freelists.org/webpage/oracle-l