Home -> Mailing Lists -> Oracle-L -> Re: Testing for Upgrade using Dataguard Standby

Re: Testing for Upgrade using Dataguard Standby

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 25 Mar 2021 00:41:13 -0400
Message-ID: <c97bc738-00f3-76da-79e7-2a7f52f34820_at_gmail.com> 





  
    
  
  
    
Hi Andrew,

    
In principle, upgrading snapshot standby to a higher version
      should work. However, I am not sure that the redo log entry format
      is the same. I suspect that it is not the same since Oracle 19c
      supports pluggable databases which can be independently recovered.
      The pluggable database to which the changed block belongs to must
      somehow be written into the redo log entry. I am not sure whether
      Oracle 11g will know what to do with those new and improved redo
      logs which it will need to undo all the changes. To tell the
      truth, I have never tried that. I no longer have Oracle 11 but
      will try with Oracle 12.2, the lowest version I have,  on my
      VirtualBox toy store. Please note that my test will not be
      relevant for you because 12.2 and 11,2 may well have different log
      formats as well.

    

    
Regards

    

    
On 3/23/21 3: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.'

        

      

    

    
-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com


  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 25 2021 - 05:41:13 CET












Original text of this message