Re: Testing for Upgrade using Dataguard Standby

Partly depends on your environment doesn't it?

If it's your only standby for production and something goes wrong during the test, how will you recover the standby and is the impact on production acceptable? (Do you have to take production offline if you have no standby active?)

If it's not your only standby, the answer may be different.

Regards,

John Thomas

On Wed, 24 Mar 2021 at 13:39, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Hi Tim-
> Yes, I have used a snapshot standby before. However, I have not used it to
> test a db version upgrade in the past, and I am concerned there are
> additional steps I need to be concerned with after testing the upgrade is
> complete, and I revert back to the previous version.
>
> As far as I can tell, after testing is complete and I want to revert back
> to the 11.2.0.4 version and put it back in redo apply, I just shut down the
> db, startup mount from the 11g home, and tell it to convert to a physical
> standby. Are there any additional steps due to the upgrade process, such
> as backing up the control file before the upgrade?
>
>
>
>
> On Tue, Mar 23, 2021 at 8:16 PM Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
>> This is known as a "snapshot standby" and here are some step-by-step
>> instructions against which you can compare...
>>
>>
>> https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/ha/dataguard/usingsnapshot/usingsnapshot.htm
>>
>>
>>
>> On 3/23/2021 12:54 PM, Andrew Kerber wrote:
>>
>> For reasons too numerous to list, it is necessary for us to do some
>> upgrade validation testing on our existing dataguard standby of
>> production. This is an upgrade from 11.2.0.4 to the latest 19c version.
>> These are the steps I can see as needed for the process of validation and
>> testing:
>>
>> 1. Install and patch the 19c software to the most recent version.
>> 2. Create a guaranteed restore point on the standby database.
>> 3. Open the standby database read-write.
>> 3. Run DBUA to upgrade the snapshot standby to 19c.
>> 4. Run testing as required
>> 5. Shutdown standby
>> 6. startup mount the standby from the 11g home and revert to the
>> guaranteed restore point.
>> 7. Resume the redo apply on the standby.
>>
>> Am I missing a step here? Will there be a problem with the control files
>> when I flash the database back to the restore point after an upgrade? I
>> would think there would not be a problem since oracle should be designed to
>> handle this, but I have tried an upgrade of a snapshot standby before,
>> though I have done other destructive testing of course.
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>>
>>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l