3 Replies Latest reply: Apr 25, 2013 7:04 PM by Aman.... RSS

    DB_RECOVERY_FILE_DEST on a network share?

    MSandico
      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
          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
            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....
              >
              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....