Solved

Redo/Archive Logs storage requirements

Posted on 2013-12-03
6
375 Views
Last Modified: 2013-12-12
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?
0
Comment
Question by:NytroZ
  • 3
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39693579
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
 
LVL 23

Expert Comment

by:David
ID: 39693597
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
 

Author Comment

by:NytroZ
ID: 39693604
So a set of disks for the redo/archive logs and then maintain a copy of those on the backup disks ?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39693616
>>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
 

Author Comment

by:NytroZ
ID: 39693671
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39693719
>>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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now