[askdba] Re: How to resolving Archive Log destination getting full?

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Sun, 18 Sep 2005 13:38:59 -0400

Check if the previous backups are done propelry.
 remove all the archive log files before the backup.
 or keep on moving. Purging is the best idea.
 regards - Chirag 

 On 9/16/05, Thiagoo <thiagoodba@xxxxxxxxx> wrote: 
>  Hi,
>  Yesterday, I had problem with Archive Log, Pls tell me whether am I 
> following the right steps.
>  My Prod Archive Log destination got full. No one was able to connect to 
> the DB, it was hanging.
>  The Tivoli Storage Monitor which should have alerted me, but it didnt 
> work for some reason in their server.
>  Once the Archive Log destination got full 100%, I got the page and when I 
> realized that it must be with ARCH log, I started moving few ARCH files to a 
> temporary folder and started RMAN backup(for ARCH Files only) & once backup 
> is done it will delete the ARCH files and I moved back those ARCH files from 
> the temporary folder to the original destination.
>  Moving those ARCH log files from one folder to another will it cause 
> corruption? My colleague cautioned that this corrupted files may corrupt the 
> whole RMAN database and we will loose the whole backup, Pls explain.
>  TIA
> -Thiagu
>  ------------------------------
> Yahoo! for Good
> Click here to donate <http://store.yahoo.com/redcross-donate3/> to the 
> Hurricane Katrina relief effort. 

Other related posts: