Re: Testing for Upgrade using Dataguard Standby

Hi Tim-
 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