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?
NytroZAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I see no reason they cannot share disks.

The more important issue is they should be multiplexed on several sets of disks (archived ones not as important but you should do it if you can).  Typically to do this, some disk sharing takes place.

For example:  I have a set of online redo logs on my backup disks so I can keep the extra set around.
0
 
DavidSenior Oracle Database AdministratorCommented:
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.
0
 
NytroZAuthor Commented:
So a set of disks for the redo/archive logs and then maintain a copy of those on the backup disks ?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
slightwv (䄆 Netminder) Commented:
>>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.
0
 
NytroZAuthor Commented:
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
0
 
slightwv (䄆 Netminder) Commented:
>>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.
0
All Courses

From novice to tech pro — start learning today.