DB startup error

[Former Member]

Hi. Experts.

I am getting the error below while starting the oracle 11g database.

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 2) The system cannot find the file specified.

Experts Please Help.

Thanks

Mohd Basis

[former_member188883 · Accepted solution]

Hi ,

Just remove the parameter db_recovery_file_dest from initSID.ora file.

Shutdown the Oracle database

execute statup mount

SQL> Create spfile from pfile;

shutdown

startup

Please follow above steps and share the results.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Dear Deepak.

Thanks for you response. Actually in initSID.ora the parameter value for db_recovery_file_dest is db_recovery_file_dest='D:\oracle\SOL\oraflash' so i checked and there was oraflash directory oraflash missing under D:\oracle\SOL. I shutdown the D.B copied the oraflash directyory under D:\oracle\SOL., which i found under D:\oracle\SOL.\oraarch. After copying it i started the D.B and the DB got started.

Thanks for your help

Regards

Mohd Basis.

[former_member188883 · Accepted solution]

Hi Mohd.

Good to know problem is resolved. You may close this thread.

Regards,

Deepak Kori

[Former Member]

as Deepak Kori said remove the parameter and create SPfile from PFile.

[former_member182657]

Hi,

Please follow link as below:

ITToolkit: Startup fails with ORA-01261: Parameter db_recovery_file_dest destination string cannot b...

Regards,

Gaurav