ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarShripad Musale
  • 06 Feb, 2024
  • 0 Comments
  • 49 Secs Read

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

Error:
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated.
ORA-01262: Stat failed on a file destination directory.


Solution:

  • Open Pfile

        check db_recovery_file_dest parameter in pfile.

  • SQL> show parameter db_recovery_file_dest
    NAME                         TYPE             VALUE
    -----------------------     -----------    --------------
    db_recovery_file_dest        string            0
    db_recovery_file_dest_size   big integer       0
  • If  db_recovery_file_dest  parameter is not set to destination string ( for example :/u01/app/oracle/fast_recovery_ area) as Pfile then first create directory on server level.
    !mkdir -p /u01/app/oracle/fast_recovery_area
  • And set parameter using below command.
    SQL> alter system set db_recovery_file_dest_size=10G;
    System altered.
    SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area';
    System altered.
    SQL> show parameter db_recovery_file_dest
    NAME                         TYPE        VALUE
    -----------------------     ----------- ------------------------------
    db_recovery_file_dest        string      /u01/app/oracle/fast_recovery_area
    db_recovery_file_dest_size   big integer  10G