This content has been marked as final. Show 3 replies
1 person found this helpful
MSandico wrote:and what happens when (not if, when) you have a network issue and your database cannot read/write the FRA ....
Oracle 11G on Windows 2008 R2 Standard edition
Currently my FRA is on a local drive and we are looking/considering moving it to a network share (where it can go to tape automatically, etc..) (i.e. \\backuplocation\servername)
I cannot find any best practices on Oracle site for this but wondering if anyone had any recommendations for/against attempting this.
Thanks in advamce
I'm just sayin' ....
Good point. As i'm stilll learning Oracle database admin, i guess i look at my orafra and notice that ArchiveLogs are currently being written there. I think the archive logs are backups of the redo logs..so to your point, if the network drive becomes unavailable, then i won't be able to archive the redo logs (let alone running a backup job).
If my understanding is correct, then will Oracle database 'stop' if it cannot archive a redo log? (since its pointing to an fra thats on an inaccessible network drive)
>1 person found this helpful
If my understanding is correct, then will Oracle database 'stop' if it cannot archive a redo log? (since its pointing to an fra thats on an inaccessible network drive)Yep, it will get hang.