Redo/Archive Logs storage requirements

Posted on 2013-12-03
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?
Question by:NytroZ
  • 3
  • 2
LVL 76

Accepted Solution

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.
LVL 23

Expert Comment

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.

Author Comment

ID: 39693604
So a set of disks for the redo/archive logs and then maintain a copy of those on the backup disks ?
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.

Author Comment

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
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.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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.

920 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

17 Experts available now in Live!

Get 1:1 Help Now