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