Re: Hot Standby Question

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 Received on Tue Mar 13 2007 - 14:11:58 CDT