Re: Separating online redo logs from database files
- From: Denis <denis.sun@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 8 Apr 2010 06:25:11 -0700 (PDT)
> What are general pros and cons on separating redo logs from database files?
Both database and redologs are already residing on RAID1
> volumes. So this separation would only mean – move redo logs to separate
mount point (RAID1, still).
From my experience and at least in my env, I think seperation of redo and data
file into different mont point is desirable. We use NetApp snapshot as backup
solution. When restoring data files, we can choose not to restore redo
log files if they are separated. Learned from the storage team, Snapshot
restore can not proceed at data file level as RAMN does. Hope I got
this impression right.
Yu "Denis" Sun
Oracle DBA
Other related posts:
