This discussion is archived
3 Replies Latest reply: Apr 25, 2013 5:04 PM by Aman.... RSS

DB_RECOVERY_FILE_DEST on a network share?

MSandico Newbie
Currently Being Moderated
Hi All,

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
  • 1. Re: DB_RECOVERY_FILE_DEST on a network share?
    EdStevens Guru
    Currently Being Moderated
    MSandico wrote:
    Hi All,

    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
    and what happens when (not if, when) you have a network issue and your database cannot read/write the FRA ....

    I'm just sayin' ....
  • 2. Re: DB_RECOVERY_FILE_DEST on a network share?
    MSandico Newbie
    Currently Being Moderated
    Hi Ed,

    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)

    thx
  • 3. Re: DB_RECOVERY_FILE_DEST on a network share?
    Aman.... Oracle ACE
    Currently Being Moderated
    >
    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.

    Aman....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points