Re: quick question on cloning and patch levels..
From: joel garry <joel-garry_at_home.com>
Date: Thu, 15 Jan 2009 13:12:24 -0800 (PST)
Message-ID: <c70628e4-a1f5-46b5-ba3e-d8afe06e4deb_at_g1g2000pra.googlegroups.com>
On Jan 15, 12: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
Date: Thu, 15 Jan 2009 13:12:24 -0800 (PST)
Message-ID: <c70628e4-a1f5-46b5-ba3e-d8afe06e4deb_at_g1g2000pra.googlegroups.com>
On Jan 15, 12: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
I believe you should use the exact same patch level. Use the Patches & Updates Quick Links, 9206 is there. Read the windows 32-bit readme, system requirements say Windows 2003, among others.
jg
-- _at_home.com is bogus. What's in your database, Barney Fife? http://www3.signonsandiego.com/stories/2009/jan/15/1n15scotus235747-evidence-seized-faulty-arrest-can/?uniontribReceived on Thu Jan 15 2009 - 15:12:24 CST