Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 542
  • Last Modified:

Setting Oracle 11g Flash Recovery Area

Is it possible to specify the flash recovery area for RMAN backups to be on a seperate server?

At present our database, archive logs and RMAN backups are on the same disk,  Not good !!!

So I would really like to specify something like this:-

Alter system set db_recovery_file_dest= '//SERVER2/oracle/flash_recovery' scope=both;

From the research I have done though, It seems that this has to be a local disk???

Failing this - Is it valid to host the redo logs on a seperate server to the DB?

Many Thanks
0
cobaplas
Asked:
cobaplas
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
I don't have the sources to back up this opinion -- but adding additional server(s) adds more unmitigated risk.  A simple example of the effort to restore three servers at a business continuity site (disaster recovery) should be self-evident.  That said, it's generally a good step to copy your archive logs onto a separate host or two.

And, a lot depends upon what sizes and software versions you're working with.  Your actual results will vary.....

So, what do you have (in general), and what do you consider your costliest risk?
0
 
cobaplasAuthor Commented:
Adding additional servers adds more risk?  Sorry but I unsure where you are with this? I would think it mitigates the risk.

We have an Oracle server with the database, archive logs and rman backups (each evening) on the same disk.

If I locate the archive logs on another server then I am spreading my risk as in the event of a failure on the main server, I can simply restore from a copied database and replay the logs that will be on a server that has not failed.

Copying the logs now and again will not work as they will never be up to date...

The question is therefore can I specify the recovery_destination for the archive logs to always reside and be updated on a different server.

Its Oracle 11g by the way
0
 
DavidSenior Oracle Database AdministratorCommented:
To address your latest question, I think that the first recovery destination must always be local to the database server.  Multiple archive logfile destinations require additional hosts, not necessarily servers.  Semantics, but I'm trying to be understood clearly.

Adding hosts means additional hardware to back up and restore, in addition to network services -- laying aside web-enabled access for the moment.  I consider multiple archive logfile destinations as I would any offsite backup storage -- having relatively very low risk of failure.  Separating binaries, data files, and non-data files is a hallmark of the Oracle Flexible Architecture (OFA), but we're still talking just one database server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now