Friday, October 19, 2018

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

DB_RECOVERY_FILE_DEST parameter is used to set Fast Recovery Area for the instance and  archived logs, flashback logs, and RMAN backups are kept at this location and are automatically handled by the database. While using ALTER SYSTEM command to set db_recovery_file_dest parameter you might face following error.

SQL> alter system set db_recovery_file_dest='location=d:\test';
alter system set db_recovery_file_dest='location=d:\test'
*
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 123) The filename, directory name, or volume label syntax is
incorrect.
In case value for this parameter is set in init file, you may face same error while starting up the instance.
This error would come if directory path does not pre-exist before setting this parameter to that location.
To avoid this error, make sure that you have already created the directory path that you are going to specify in db_recovery_file_dest parameter either using ALTER SYSTEM command, or by specifying in init file. You must also make sure that oracle user (oracle software owner) also has write privileges on this directory that is being specified in this parameter.

No comments:

Post a Comment

Popular Posts - All Times