Unsolved
This post is more than 5 years old
1 Message
0
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
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
No Events found!
bodnarg
2 Intern
•
385 Posts
0
April 17th, 2008 11:00
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.