Flash recovery to another server [message #455253] |
Mon, 10 May 2010 18:18 |
itsjoebarton
Messages: 6 Registered: May 2010
|
Junior Member |
|
|
Hi
Is it possible to set up a flash recovery area on another server?
alter system set db_recovery_file_dest='//ourserver/z$/DataBaseBackups/Oracle/oraserver/FlashRecoveryArea';
SQL> alter system set db_recovery_file_dest='//ourserver/z$/DataBaseBackups/Orac
le/oraserver/FlashRecoveryArea';
alter system set db_recovery_file_dest='//ourserver/z$/DataBaseBackups/Oracle/oraserver/FlashRecoveryArea'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_recovery_file_dest destination string cannot be
translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 5) Access is denied.
Joe
|
|
|
|
|
Re: Flash recovery to another server [message #455450 is a reply to message #455286] |
Tue, 11 May 2010 11:05 |
itsjoebarton
Messages: 6 Registered: May 2010
|
Junior Member |
|
|
Black Swan, Michel,
Thanks for your input. The target server is boing to be used for all database backups, and managed as such. In the case, a share may need to be placed on that volume for the SQL service account, then the Z$ is replaced by the share name. This may work. My primary goal is to central all database backups on this server.
Joe
|
|
|
|
|