RE: More than one archivelog disk
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- Date: Fri, 17 Nov 2006 09:14:28 -0500
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@xxxxxxxxx]
Sent: Friday, November 17, 2006 9:07 AM
To: Kline.Michael
Cc: oracle-l@xxxxxxxxxxxxx
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]
Other related posts:
