Link to home
Start Free TrialLog in
Avatar of cobaplas
cobaplasFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

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?
Avatar of cobaplas

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial