Home -> Mailing Lists -> Oracle-L -> Re: intermittant rman compression errot

Re: intermittant rman compression errot

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 28 Oct 2021 21:27:06 -0400
Message-ID: <534023f5-0432-3be4-a063-5737b23fb81f_at_gmail.com> 





  
    
  
  
    


    

    
On 10/28/21 05:52, Howard Latham wrote:

    

    

      
      

        
Oracle
          19.13

        
Redhat
          7.9

        


        

        
Hi
          Colleagues,

        
Another
          Oracle Mystery!

        
Repeatedly
          Out of about 20 identical runs of rman we get the below
          error.  We are using basic because we aren't licenced for
          anything else. and we are using release 19.12 any ideas?

        


        

        
ORA-19962:
          compression algorithm BASIC is not valid with release
          0.0.0.0.1

        

        


        

        

          

            

              
Best Wishes

              


              

              
Howard A. Latham

                

                

              

            

          

        

      

    

    


    

    
Wow! Release 0.0.0.0.1 was long before my time. I started with
      Oracle 4.14 on MS-DOS 3.3 but haven't fully mastered it until 5.0
      on VAX/VMS. In other words, I am a novice with Oracle. However,
      why are you setting compression algorithm in RMAN settings? You
      don't need to do that. Backup as compressed backupset will work
      without compression being set in RMAN. Also, you can use
      commercial backup utilities like NetBackup, Avamar, DD Boost or
      Rubrik which have both compression and deduplication.  Your space
      savings will be better than with compression only. Backup is too
      serious of a thing to be left to rman.

    

    
Regards

    

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


  

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 29 2021 - 03:27:06 CEST












Original text of this message