[Oracle issue set 7] ORA-01261: Parameter db_recovery_file_dest desti

Note: [oracle problem set] refers to the problems and solutions encountered by bloggers during database operations.

Statement execution: indicates the database operation process. Error: Indicates An error occurred while operating the database. Error cause: indicates the cause of the error. Solution: indicates the solution to the error. Related Knowledge: indicates the knowledge related to this topic.

========================================================== ========================================================== ======

Execute the statement:

Start database startup

Error:

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

Error cause:

The hard disk corresponding to db_recovery_file_dest is not mounted, that is, the directory cannot be found in db_recovery_file_dest.

Solution:

Method 1: Delete the directory configuration corresponding to db_recovery_file_dest in the spfile parameter file.

Method 2: mount the corresponding directory (use the mount command to Solve the Problem)

Note: This article provides detailed procedures for the first method.

Init. ora.117201120430

Related Knowledge:

In step 1, the startup database reports a control file error.

'/Home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl' version 4106
Inconsistent with file '/home/oracle/app/oracle/oradata/orcl/control01.ctl'
Version 9971:

The reason is: the version of the init. ora control file is inconsistent. just delete the redundant control file configuration parameters.

In step 4, flashback startup fails.

SQL> startup
ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 260049280 bytes
Database Buffers 155189248 bytes
Redo Buffers 6094848 bytes
Database mounted.

The reason is that the current database has enabled the flash recovery function.