Re: Dataguard Archive Logs

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Thu, 6 Jan 2011 17:26:25 +0200
Message-ID: <OF9A5B846B.A582017B-ONC2257810.00548AC2-C2257810.0054D144_at_seb.lt>

if you want Oracle to do auto-magic for you then try rman archive log delete policy. archive logs must be in oracle flashback recovery area.

      rman> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

then search metalink for one hidden parameter, I think *._log_deletion_policy='ALL'.

---

Please consider the environment before printing this e-mail

                                                                           
             Patrick Elliott                                               
             <elliotp1_at_msn.com                                             


             >                                                          To 

             Sent by:                  <oracle-l_at_freelists.org>            
             oracle-l-bounce_at_f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       Dataguard Archive Logs              
             2011.01.06 16:36                                              
                                                                           
                                                                           
             Please respond to                                             
             elliotp1_at_msn.com                                              
                                                                           
                                                                           

I have a physical dataguard database on a development system in noarchivelog mode. The archive log directory keeps filling up. Since it is development, I do not need to keep the archive logs. They are already backed up on the production database. How do I get the dataguard database to stop archiving?

Patrick Elliott
"You don't truly fail until you quit."

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

Received on Thu Jan 06 2011 - 09:26:25 CST