Re: Separating online redo logs from database files

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