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@xxxxxxxxx [mailto:dtseiler@xxxxxxxxx]On Behalf Of Don Seiler Sent: Tuesday, August 07, 2007 11:25 PM To: Robert Freeman Cc: kedeshpande@xxxxxxxxx; 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@xxxxxxxxx> 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kirtikumar Deshpande > Sent: Tuesday, August 07, 2007 8:21 PM > To: don@xxxxxxxxx; 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@xxxxxxxxx> 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@xxxxxxxxx> wrote: > > > On 8/1/07, Alex Gorbachev <ag@xxxxxxxxxxxx> 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 > > -- > > //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/ > -- > //www.freelists.org/webpage/oracle-l > > > -- Don Seiler oracle: http://ora.seiler.us ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l