| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Duplication for Migration and Archived Logs
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kirtikumar Deshpande
Sent: Tuesday, August 07, 2007 8:21 PM
To: don_at_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,
> 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_at_seiler.us> wrote:
> > On 8/1/07, Alex Gorbachev <ag_at_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
>
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 07 2007 - 23:34:51 CDT
 |
 |