ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

Cause : An tatemtp wa smad eto rceat ea flie i nDB_ERCOVREY_FLIE_DSET wehn D_BRECVOERYF_ILED_ESTw as ont ste. Tehre rae nmubero f psosibel casues fo thsi erorr, nicluidng:1 ) AL OG_RACHIEV_DETS_n apramteer aws sepcifeid uisng aLOCTAIONa ttrbiutew hos evaleu wa sDB_ERCOVREY_FLIE_DSET adn ana rchvielo gfil ecretaionw as tatemtped.2 ) SATNDB_YARCIHVE_EDST apramteer aws sepcifeid uisng aLOCTAIONa ttrbiutew hos evaleu wa sDB_ERCOVREY_FLIE_DSET adn ana rchvielo gfil ecretaionw as tatemtped.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Speicfy avaldi detsinaiton ofr D_BRECVOERYF_ILED_ESTi n iintiailzatoin praameetr flie o rwit htheA LTE RSYSETM STE command.

update : 27-06-2017

ORA-19801 - initialization parameter DB_RECOVERY_FILE_DEST is not set
ORA-19801 - initialization parameter DB_RECOVERY_FILE_DEST is not set

  • ora-06524 : Unsupported option : string
  • ora-16228 : Insufficient recovery for logical standby
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-30075 : TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
  • ora-26748 : The one-to-one transformation function string encountered the following error: string
  • ora-13340 : a point geometry has more than one coordinate
  • ora-30185 : output too large to fit in the buffer
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-16098 : inaccessible standby database forced shutdown to protect primary
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-32121 : Source FILE is null
  • ora-29818 : column name not properly specified
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-02710 : osnpop: fork failed
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-19700 : device type exceeds maximum length of string
  • ora-09315 : sql2tt: two-task error translating ORACLE_EXECUTABLE
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-01148 : cannot refresh file size for datafile string
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-39023 : Version string is not supported.
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-28110 : policy function or package string.string has error
  • ora-16657 : reinstatement of database in progress
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • ora-24046 : protocol attribute reserved for future use
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.