Re: RMAN Duplication for Migration and Archived Logs

  • From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
  • To: don@xxxxxxxxx
  • Date: Thu, 2 Aug 2007 07:11:18 -0600

Apparently when I moved from 32-bit to 64-bit, I was given bad advice.  I
was told that you couldn't apply 32-bit archived redo to a 64-bit database.
Was this really bad advice?  I need to do this migration again and would
like a cleaner method than the last time I did this.

Sandy


On 8/1/07, Don Seiler <don@xxxxxxxxx> wrote:
>
> So, could I then:
>
> 1. Initiate the DUPLICATE FOR STANDBY at say 12:00 Noon on Saturday,
> and let it process whatever backups and archived logs are available.
> 2. As more archived logs are backed up throughout the day and those
> backup pieces rsynced, apply them manually.
> 3. At 10 PM (when the downtime window starts), "flip the switch" to
> make the standby our live production database.
>
> Do you know off-hand where I would need to do the recompile for the
> word-size change?
>
> I've just found the standby documention (Appendix F in the Data Guard
> guide [1]), so I'll start reading up on that now.
>
> [1]
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rcmbackp.htm#i636377
>
> On 8/1/07, Alex Gorbachev <ag@xxxxxxxxxxxx> wrote:
> > We use DUPLICATE FOR STANDBY all the time.
> > Works like a charm (don't forget to create standby controlfile with RMAN
> first).
> > Basically, DUPLICATE FOR STANDBY does the same and normal DUPLICATE
> > but doesn't open database at the end and also restores standby
> > controlfile instead of normal one.
> >
> > On 8/1/07, Don Seiler <don@xxxxxxxxx> wrote:
> > > Alex, thanks for the tip.  I was going to ask about the possiblity of
> > > creating the new production box as a standby first.  Can RMAN be used
> > > to set up the new standby DB?  I haven't done anything in the standby
> > > arena yet.  I'll look into the "duplicate for standby" command set.
> >
> >
> > --
> > Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
> > http://www.pythian.com/blogs/author/alex http://www.oracloid.com
> > BAAG party - www.BattleAgainstAnyGuess.com
> >
>
>
> --
> Don Seiler
> oracle: http://ora.seiler.us
> ultimate: http://www.mufc.us
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: