Re: quick question on cloning and patch levels..

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 15 Jan 2009 17:18:43 -0800 (PST)
Message-ID: <ea0db7f0-c7e8-4f61-b09d-ab684a41cf53_at_j35g2000yqh.googlegroups.com>

On Jan 15, 3:07 pm, GS <g..._at_gs.com> wrote:
> Was going to open an SR for this, but time is tight so:
>
> The situation -
>
> Server running production database on 9ir2 is in a degraded state so I
> am moving 9.2.0.6 database over to new hardware imminently.
>
> Same platform more or less, a bit more RAM and CPU, windows 2003 server
> etc.. was going to migrate to 10G on server 2008 on this hardware but am
> delaying in order to expedite this.
>
> Installing Oracle and patching to 9.2.0.8, create instance and restore
> from latest online backup by copying files over and recreating control
> files, recover from backup controlfile until cancel, apply redo up till
> latest then shutdown production and apply the last redo log.
>
> Now, since I am at different patch level (0.6 to 0.8) I am thinking that
> I just bounce the db, startup migrate and run the catpatch.sql etc. and
>   I am good to go.
>
> Otherwise I just patch to 0.6 to save time and wait until 10G migration
> later this year. Trouble is I think 0.6 patch is gone, so if I do the
> above step all should be ok, correct?
>
> thanks in advance

How big is the database? Got time to create new instance in 9.2.0.8 and use exp/imp to move?

Otherwise most of your approach may work but I would go 9.2.0.6 to 9.2.0.6 then patch to 9.2.0.8 after you get it moved over.

Do you have to stick with 9.2 it is getting pretty old? Received on Thu Jan 15 2009 - 19:18:43 CST