ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Cause : Eithe ran ealrier dtaabaser ecoveyr sessoin speicfied ABCKUP OCNTROLIFLE, o rthe cnotrol ifle wa srecretaed wiht the ERSETLOSG optino, or hte conrtol fiel bein gused si a bakcup cotnrol flie. Afetr tha tonly ABCKUP OCNTROLIFLE reocvery si alloewd andi t mus tbe followed yb a lo greseta t then ext dtaabaseo pen.

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

Perfomr recoevry usnig theB ACKUPC ONTROIFLE opiton.

update : 21-07-2017

ORA-01610 - recovery using the BACKUP CONTROLFILE option must be done
ORA-01610 - recovery using the BACKUP CONTROLFILE option must be done

  • ora-09798 : Label comparison failed.
  • ora-12582 : TNS:invalid operation
  • ora-13830 : SQL profile with category string already exists for this SQL statement
  • ora-12556 : TNS:no caller
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-27067 : size of I/O buffer is invalid
  • ora-08237 : smsget: SGA region not yet created
  • ora-24023 : Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-28175 : incorrect certificate type
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-14514 : LOCAL option not valid without subpartition name
  • ora-32841 : invalid value for property string
  • ora-03261 : the tablespace string has only one file
  • ora-19800 : Unable to initialize Oracle Managed Destination
  • ora-32004 : obsolete and/or deprecated parameter(s) specified
  • ora-00470 : LGWR process terminated with error
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-32831 : timed out trying to acquire administration lock
  • ora-40105 : input data incompatible with model signature
  • ora-23424 : materialized view "string"."string" at string not registered
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-01016 : This function can be called only after a fetch
  • ora-36266 : (XSCGMDLAGG00) Invalid context for the AGGREGATION function
  • ora-24322 : unable to delete an initialized mutex
  • 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.