Re: moving oracle database server into a new server

From: Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com>
Date: Mon, 01 Mar 2004 20:36:19 GMT
Message-ID: <79N0c.115092$Hy3.65174@edtnps89>

Rick Denoire wrote:

> Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com> wrote:
>
>
>

>>#3 Restore from online backup of old_database and apply redo logs, again 
>>recreating the controlfile to fit the new env.  (I usually only do this 
>>for "practice" and for creating a development copy of a prod db)

>
>
> If restoring using rman, what would be the limitations concerning
> cross platforms? Can I restore an rman backup only to absolutely the
> same vesion of the OS / Oracle / architecture?
>

>>#2 is usually the "easiest" / fastest, but since your OS's are at 
>>different patch levels I'd think #1 is the best for you.
>>
>>I'm sure I'll be corrected here in short order if others think 
>>differently however
>>
>>hth

>
>
> Bye
> Rick Denoire

Restoring databases, be it Rman or via the OS, has to be done to the same OS/Oracle version. As a practice, I always make sure both OS and Oracle are patched to the same level, if directory structure has changed then recreate the controlfile to reflect this.

I understand that 10G does not have this limitation, and can restore and even apply redo cross-platform, but I havent had a chance to try it yet.

hth Received on Mon Mar 01 2004 - 14:36:19 CST