Re: RMAN Duplication for Migration and Archived Logs

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_at_seiler.us> 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_at_oracloid.com> 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_at_seiler.us> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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