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.

4 comments:

  1. how to make it happened with no error? could you show cmd examples?

    ReplyDelete
    Replies
    1. Make sure that directory already exists and oracle user has permission on that directory.

      Delete
  2. You've shown the error, but not shown the Solution. Pls show solution with images and command.

    Some people who are beginners visit here.

    ReplyDelete
    Replies
    1. Last 3 lines of the post is the solution :)
      If you face this error during startup, make sure that your init or spfile have correct path (and physical directory exists)
      If you face during ALTER SYSTEM command to set his parameter, make sure you have mentioned correct path.

      Delete

Popular Posts - All Times