Re: quick question on cloning and patch levels..
From: bdbafh <bdbafh_at_gmail.com>
Date: Fri, 16 Jan 2009 08:46:07 -0800 (PST)
Message-ID: <b4fcc26a-7e6a-436f-a028-5758e0658664_at_k1g2000prb.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
Date: Fri, 16 Jan 2009 08:46:07 -0800 (PST)
Message-ID: <b4fcc26a-7e6a-436f-a028-5758e0658664_at_k1g2000prb.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
If you are going to restore a cold (cleanly shutdown, consistent)
backup set, then upgrading to the 9.2.0.8 binaries will be
straightforward. Go for it.
If you are going to restore a fuzzy backup (rman db backup of an open
database, hot physical) and apply archived redo logs during media
recovery, then using anything other than the same patchset level may
cause problems.
A complete test run would prove it in your environment.
hth.
-bdbafh Received on Fri Jan 16 2009 - 10:46:07 CST