cobaplas
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_re covery' 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
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_re
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?