On Mar 13, 3:11 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Mar 13, 2:03 pm, "Paul" <paul..._at_gmail.com> wrote:
>
> > We are in the process of setting up a hot standby database for an
> > Oracle 8i application. The question I have is how would we be able to
> > apply quarterly patches without having to re-create the stand by
> > database every quarter.
>
> > We have found that the database needs to be taken out of read-only
> > mode to apply the patch. However after the database is taken out of
> > read-only mode, it can't be put back.
>
> > Is there a way to apply the patches without having to rebuild the
> > database every quarter ?
>
> > Thank you.
>
> > Paul LaBarbera
>
> Not if you also need to update the data dictionary, which is part and
> parcel of database patches and upgrades. The answer to your question
> is 'No'. The interesting part of all of this is that you've likely
> already upgraded/patched the source database prior to patching/
> upgrading the software on the standby server. Would it not be easier
> to:
>
> 1) Patch/upgrade the source server.
> 2) Patch/upgrade the software on the standby server.
> 3) Re-instantiate the standby with a clone of the now-patched source.
>
> It should save you a step since you're cloning an upgraded data
> dictionary to your standby server. Either way you need to create a
> new clone of your source for the now-patched standby server. You may
> as well stop the process at the software upgrade/patch on the standby
> and setup a new standby with a clone of your now-modified source.
>
> My two cents.
>
> David Fitzjarrell
>
> David Fitzjarrell
Is this 8i? I highly doubt there are any [quarterly] updates available
for it.
Received on Tue Mar 13 2007 - 14:20:02 CDT
