Solved

Redo/Archive Logs storage requirements

Posted on 2013-12-03
6
380 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 77

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 77

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 77

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query for highest sequence 4 75
join actual table rows based on the column 25 44
oracle forms question 22 61
Convert CSV to list in oracle for IN-Clause 6 48
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

752 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