Thursday, April 11, 2019

Oracle database startup fails 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 Linux-x86_64 Error: 2: No such file or directory

Problem Description
While I start my database with my initialization parameter it fails with oracle error

Solution of The Problem

su oracle 
run environment variable
sqlplus / as sysdba 
SQL>create pfile from spfile;

Then remove or comment below line in pfile

db_recovery_file_dest  

Save and exi

su oracle 
run environment variable
sqlplus / as sysdba 
SQL>startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size                  2166536 bytes
Variable Size             427819256 bytes
Database Buffers          624951296 bytes
Redo Buffers               14000128 bytes
it should  became the mount stage then open the DB as follows 

SQL>alter database open;

Database altered.

SQL>

No comments:

Post a Comment

How can I restore Cassandra snapshots?