Re: Question about dataguard and Security Patch

cs charlie (nospam) wrote:
> Group,
>
> I have a question, and hope this group can help me out.
>
> I have a test environment, which has a test database and a standby database,
> then a production.
>
> Our policy as to Oracle security patch is: applying it to test for 2 weeks
> before applying it to production.
>
> So, during this 2 weeks, the software on test(which where standby database
> sits on) is different from production, will there be any data corruption
> issue in terms of dataguard?
>
> Your help is appriciated.

A standby database if it is part of your tested and ready to go disaster recovery procedures should be patched to be at the same level as the production database that it is a standby for.

Any other setup is just asking for trouble.

You can install oracle in a different home so that you have 2 separate oracle homes in your current setup and then switch the standby to operate out of it's own oracle home.

Then patch the test environment first and do your validation and acceptance testing of the patches without affecting how the standby operates. Received on Sat Oct 28 2006 - 14:22:26 CDT