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.
how to make it happened with no error? could you show cmd examples?
ReplyDeleteMake sure that directory already exists and oracle user has permission on that directory.
DeleteYou've shown the error, but not shown the Solution. Pls show solution with images and command.
ReplyDeleteSome people who are beginners visit here.
Last 3 lines of the post is the solution :)
DeleteIf 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.