Start a Conversation

Unsolved

This post is more than 5 years old

318

April 17th, 2008 09:00

Database archive log placement on SAN storage

Hello,

I have a question regarding database archive log placement on SAN disk.

1. Is duplex archive logging typically used for all database configurations?

2. Are the archive log copies separated onto different physical storage volumes?, and separate volume groups?
- allowing local recovery in the event of data loss of a single volume

My primary focus is Oracle and DB2 implementations, however I believe the same questions would apply for most database instances.

Thanks in advance

Ryan

2 Intern

 • 

385 Posts

April 17th, 2008 11:00

Assuming duplex archiving means writing the same transaction log to 2 seperate physical files, then the answer (in my experience) is that this is not a normal occurence especially in a SAN environment. You do your mirroring at the array level to match your risk threshold. (i.e. you can do 3 mirrors, remote site mirroring, etc.) Avoiding doing duplex archive logs cuts-down on some overhead to your host by letting your storage array (which is optimized to do it) handle the extra write overhead.

As for 2) it is definitely in your best interest both for logistical (backup, recovery, replication, etc.) and performance reasons to have your archive logs and core database volumes isolated on different volume groups and physical drives. This is definitely a best practice and should be followed for all but the smallest of database environments.
No Events found!

Top