DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-YMail-OSG:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE:Importance:In-Reply-To;
  b=IaoUGABWnEv2ThT+m1LquNeTST2XNDQAs9mfgeERC8kfiMb0uMswxx4ls0bBkRMbIcOESi8isBtenRg2Yxs43/mLks0BTa1uL7h1EdgzpCTJqfW0JdD+yA2YZdJ3S64u9v9PcgqMZHTc/44F/WPFuDbZgcSpLb7ji6xjGKRqE3c=  ;
From: "Robert Freeman" <robertgfreeman@yahoo.com>
To: "Don Seiler" <don@seiler.us>
Cc: <kedeshpande@yahoo.com>,
 "Alex Gorbachev" <ag@oracloid.com>,
 "oracle-l" <oracle-l@freelists.org>
Subject: RE: RMAN Duplication for Migration and Archived Logs
Date: Tue, 7 Aug 2007 23:44:45 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOCEBGEEAA.robertgfreeman@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
In-Reply-To: <716f7a630708072225q7ce088bardb6d62a9a51b4a51@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: robertgfreeman@yahoo.com

Honestly, if you have 3 weeks to make this work and have not done streams,
I'd be very careful. Streams can be complex and has a pretty steep learning
curve.

RF

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2

-----Original Message-----
From: dtseiler@gmail.com [mailto:dtseiler@gmail.com]On Behalf Of Don
Seiler
Sent: Tuesday, August 07, 2007 11:25 PM
To: Robert Freeman
Cc: kedeshpande@yahoo.com; Alex Gorbachev; oracle-l
Subject: Re: RMAN Duplication for Migration and Archived Logs


No I really only need to copy objects and pl/sql from 3 schemas.  I do
need to recreate other users and roles, but that is easily done via a
script that I've written a few years ago anyway.

So streams will update sequence objects?  Does it also do changes to
PL/SQL objects like packages and triggers?  I'll have to resume my
overdue reading.

Right now here are the three viable paths for this migration as I see it.

1. Oracle Streams
2. Oracle Data Pump
3. RMAN Duplication

Path #1 is the one I'm virtually completely unfamiliar with at this
point in time.  Path #2 is appealing to me because it would give me
the opportunity to do some object reorganization and be a little bit
smarter with the database creation.  Path #3 is the worst-case
scenario -- one that I know will work and have already scripted (I do
it for all of my dev instance restores).

D-Day for the migration is just under 3 weeks.  So the learning curve
for #1 becomes a negative factor, but it seems to greatly reduce the
downtime if I can make it happen.  But, there may be a lot of other
positives that make it an obvious stand-out choice, once I RTFM.

Don.

On 8/7/07, Robert Freeman <robertgfreeman@yahoo.com> wrote:
> In 10.2? I am pretty sure streams can apply DDL for a sequence creation
> can't it? I don't have a streams setup handy now to test this, but I'm
sure
> that the last one I did was capturing create sequence DDL and applying it.
> In 10.2 capture will capture all DDL except about 6 different statements.
>
> I agree about SYS objects, but sequences are not all owned by SYS.
>
> RF
>
>
> Robert G. Freeman
> Oracle Consultant/DBA/Author
> Principal Engineer/Team Manager
> The Church of Jesus Christ of Latter-Day Saints
> Father of Five, Husband of One,
> Author of various geeky computer titles
> from Osborne/McGraw Hill (Oracle Press)
> Oracle Database 11g New Features Now Available for Pre-sales on
Amazon.com!
> BLOG: http://robertgfreeman.blogspot.com/
> Sig V1.2
>
> -----Original Message-----
> From: oracle-l-bounce@freelists.org
> [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kirtikumar Deshpande
> Sent: Tuesday, August 07, 2007 8:21 PM
> To: don@seiler.us; Alex Gorbachev
> Cc: oracle-l
> Subject: Re: RMAN Duplication for Migration and Archived Logs
>
>
> Hi Don,
>
>  The answer to (2) is: No. Streams can't replicate sys,system,ctxsys(?)
> owned objects.
>  You will have to deal with Sequences on your own.
>  As for 32-bit to 64-bit Streams replication, I had tested Oracle9i
(32-bit)
> to
> Oracle10gR1 (64-bit) without any problems.
>
>  Regards,
>
> - Kirti
>
> --- Don Seiler <don@seiler.us> wrote:
>
> > A friend also suggested that I might be able to do something similar
> > using Oracle Streams Replication to minimize downtime.
> >
> > I've only just begun the Streams reading, but thought I'd ask some
> > questions to get a jump-start:
> >
> > 1. Are there any known hang-ups going from 32-bit to 64-bit?
> > 2. Does Oracle Streams include sequences, or does it just do table
> > DDL/DML changes?
> > 3. Does Oracle Streams propagate VPD changes?
> >
> > If any of these are "no", then I think it's out.  One not-so-appalling
> > option would be to do as I did when I migrated from HPUX to RHEL:
> > create a new database, recreate pl/sql, tables and indexes (with
> > better organization than I have currently), have a perl script to
> > recreate users and privileges.  The appeal here is that the large bulk
> > (90%) of my ~1TB database is read-only on that day and could be
> > migrated (probably via datapump) well ahead of the downtime window.
> > Then during the downtime window I'd run a script to recreate the
> > sequences and VPD settings, then datapump the OLTP stuffs over to get
> > the DML for the day.
> >
> > What do you fine folks think?  Doing it the hard way?
> >
> > Don.
> >
> > On 8/2/07, Don Seiler <don@seiler.us> wrote:
> > > On 8/1/07, Alex Gorbachev <ag@oracloid.com> wrote:
> > > > The simple approach is to create a standby database. I think it
should
> > > > work 32 bit -> 64 bit as well.
> > >
> > > I just found this in Section 2.3.1 of the Data Guard Concepts and
> > > Administration Guide [1]:
> > >
> > > "All members of a Data Guard configuration must run an Oracle image
> > > that is built for the same platform.
> > >
> > > For example, this means a Data Guard configuration with a primary
> > > database on a 32-bit Linux on Intel system can have a standby database
> > > that is configured on a 32-bit Linux on Intel system. However, a
> > > primary database on a 64-bit HP-UX system can also be configured with
> > > a standby database on a 32-bit HP-UX system, as long as both servers
> > > are running 32-bit images."
> > >
> > > Has anyone proven this wrong?  Are my standby plans ruined?
> > >
> > > [1]
>
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/standby.htm#i
> 72053
> > >
> > > --
> > > Don Seiler
> > > oracle: http://ora.seiler.us
> > > ultimate: http://www.mufc.us
> > >
> >
> >
> > --
> > Don Seiler
> > oracle: http://ora.seiler.us
> > ultimate: http://www.mufc.us
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
>
>
____________________________________________________________________________
> ________Ready for the edge of your seat?
> Check out tonight's top picks on Yahoo! TV.
> http://tv.yahoo.com/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us

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