Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Duplication for Migration and Archived Logs

Re: RMAN Duplication for Migration and Archived Logs

From: Don Seiler <don_at_seiler.us>
Date: Thu, 2 Aug 2007 08:44:55 -0500
Message-ID: <716f7a630708020644t5c840fc9jc58a1feace8d840d@mail.gmail.com>


Sanda, as I said before, I use RMAN DUPLICATE to restore my 32-bit prod db to our 64-bit dev box. This obviously has to apply archived redo logs for the PITR.

The only caveat is that the DUPLICATE command *will* fail at the end due to the word size issues. That's when you need to follow the instructions in that MetaLink note to recompile all of the PL/SQL in the database. Should work from there on out.

Here is what you'll see when the error strikes at the end:

database opened
Finished Duplicate Db at 27-JUN-07

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12005: error during channel cleanup ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [ ]
ORA-06553: PLS-801: internal error [56319]

RMAN> Recovery Manager complete.

Don.

On 8/2/07, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> 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.

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 02 2007 - 08:44:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US