A special way of migration 2005-09-28 - By Gogala, Mladen
Unfortunately, it's not a misinformation. With "consistent=y", you will have
SET TRANSACTION READ ONLY as the first statement in the export. What does
this statement do you can read for yourself in the manual. It wasn't an
overuse of sarcasm.
As far as logical backup goes, I would tend not to disagree, but it has
nothing to do with CONSISTENT=YES. This "read consistent export" can only
ensure consistency with respect to certain point in time if it builds a
read-consistent image of the database with respect to that point in time.
You have three guesses to guess which structures are used for building
such a consistent image.
So Mark, please read the fine manual before you accuse me of being overly
sarcastic.
--
Mladen Gogala
Ext. 121
-- --Original Message-- --
From: Mark Bole [mailto:makbo@(protected)]
Sent: Wednesday, September 28, 2005 12:12 PM
Cc: ORACLE-L@(protected)
Subject: Re: A special way of migration
I started a reply on this same point, then cancelled it, but since you
(Michael McMullen) brought it up, I will add that the whole quoted
paragraph below about "consistent=y" is a jumble of misinformation.
I suggest that over-use of sarcasm intermingled with technical
information is resulting in less signal and more noise.
Exp/imp is the only way to perform a logical backup, and as such has its
legimate uses, and should not be dismissed out-of-hand. Data pump in
version 10g addresses some of the limitations of exp/imp that previously
could only be addressed at the OS level (such as using pipefiles in Unix).
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: A special way of migration</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Unfortunately, it's not a misinformation. With "consistent
=y", you will have</FONT>
<BR><FONT SIZE=2>SET TRANSACTION READ ONLY as the first statement in the export
. What does this statement do you can read for yourself in the manual. It wasn't
an overuse of sarcasm. </FONT></P>
<P><FONT SIZE=2>As far as logical backup goes, I would tend not to disagree,
but it has nothing to do with CONSISTENT=YES. This "read consistent export
" can only</FONT></P>
<P><FONT SIZE=2>ensure consistency with respect to certain point in time if it
builds a</FONT>
<BR><FONT SIZE=2>read-consistent image of the database with respect to that
point in time.</FONT>
<BR><FONT SIZE=2>You have three guesses to guess which structures are used for
building </FONT>
<BR><FONT SIZE=2>such a consistent image. </FONT>
<BR><FONT SIZE=2>So Mark, please read the fine manual before you accuse me of
being overly sarcastic.</FONT>
</P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Mladen Gogala</FONT>
<BR><FONT SIZE=2>Ext. 121</FONT>
</P>
<P><FONT SIZE=2>-- --Original Message-- --</FONT>
<BR><FONT SIZE=2>From: Mark Bole [<A HREF="mailto:makbo@(protected)">mailto
:makbo@(protected)</A>] </FONT>
<BR><FONT SIZE=2>Sent: Wednesday, September 28, 2005 12:12 PM</FONT>
<BR><FONT SIZE=2>Cc: ORACLE-L@(protected)</FONT>
<BR><FONT SIZE=2>Subject: Re: A special way of migration</FONT>
</P>
<P><FONT SIZE=2>I started a reply on this same point, then cancelled it, but
since you </FONT>
<BR><FONT SIZE=2>(Michael McMullen) brought it up, I will add that the whole
quoted </FONT>
<BR><FONT SIZE=2>paragraph below about "consistent=y" is a jumble of
misinformation.</FONT>
</P>
<P><FONT SIZE=2>I suggest that over-use of sarcasm intermingled with technical
</FONT>
<BR><FONT SIZE=2>information is resulting in less signal and more noise.</FONT>
</P>
<P><FONT SIZE=2>Exp/imp is the only way to perform a logical backup, and as
such has its </FONT>
<BR><FONT SIZE=2>legimate uses, and should not be dismissed out-of-hand.
Data pump in </FONT>
<BR><FONT SIZE=2>version 10g addresses some of the limitations of exp/imp that
previously </FONT>
<BR><FONT SIZE=2>could only be addressed at the OS level (such as using
pipefiles in Unix).</FONT>
</P>
</BODY>
</HTML>
|
|
