Re: Testing for Upgrade using Dataguard Standby

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.'

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