RE: More than one archivelog disk

I was 99% sure that is what would have to be done. Just wanted to check because as we "mature" it was possible that I had actually heard that. Good wish list item though if you were limited to the size of disks. Would be nice to keep around 1-2 days of archive logs, but some of these buggers would need that 200-300GB of disks.  

Michael Kline

Database Administration

Outside 804.261.9446

Cell 804.744.1545

3-9446  

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Friday, November 17, 2006 9:07 AM
To: Kline.Michael
Cc: oracle-l_at_freelists.org
Subject: Re: More than one archivelog disk  

Michael,  

I haven't heard of an Oracle feature that will write archive logs to different destinations such as you describe. You can write an O.S. script to check for space and move stuff around. But your use of RMAN probably rules that out. If you are using RMAN to back up your archive logs, you can simply perform that task more often, thereby reducing the amount of on-disk archive storage. Or you could remove the archive log backup from RMAN. Just manage and back up the archive logs yourself. In a recovery situation you simply produce the archive logs at the location RMAN expects them.

     But the larger issue is that you simply don't have adequate disk. Being clever can easily end up compromising the recovery prospects of this system. And if the data wasn't worth protecting, you wouldn't be so concerned. Instead of creating clever technical solutions you might better spend your time and energy pointing out to management that they need to buy more disk to protect this system.

Dennis Williams         

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.   

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc. [ST:XCL]        

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