NytroZ
asked on
Redo/Archive Logs storage requirements
Should the redo logs and the archived logs be stored on a different set of disks or is it ok for them to share disks?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I concur, particularly in the era of virtual disks and systems. The single point of failure to avoid is to maintain multiple copies, and that the copies are not kept on a single hard drive.
ASKER
So a set of disks for the redo/archive logs and then maintain a copy of those on the backup disks ?
>>and then maintain a copy of those on the backup disks ?
Not the backup disks per say, just another set of physical disks.
The online docs talk about multiplexing redo logs.
What you are trying to protect from is a disk failure taking out your only copy of the online redo logs.
I just use my backup disks out of necessity. I have 3 sets of physical disks: Logs, Data Files and Backups. I have a set of online redo logs and control files on each set of disks.
Not the backup disks per say, just another set of physical disks.
The online docs talk about multiplexing redo logs.
What you are trying to protect from is a disk failure taking out your only copy of the online redo logs.
I just use my backup disks out of necessity. I have 3 sets of physical disks: Logs, Data Files and Backups. I have a set of online redo logs and control files on each set of disks.
ASKER
I guess I assumed having the disks in a RAID would protect against that. But I get it anyhow. Just be sure to keep a copy of the redo logs on a "different" set of disks for another layer of redundancy
>>I guess I assumed having the disks in a RAID would protect against that
RAID helps but it isn't fault-tolerant.
It also doesn't protect against User error: deleting/formatting/???
Your redo logs (online and archived) are some of the most important Oracle files you have. You need to protect them every way you can.
RAID helps but it isn't fault-tolerant.
It also doesn't protect against User error: deleting/formatting/???
Your redo logs (online and archived) are some of the most important Oracle files you have. You need to protect them every way you can.