ORA-19654: must use backup control file to switch file incarnations

Cause : This swtichToCop yoperatino is attmepting t oswitch nicarnatinos of a adtafile,b ut the ucrrentlym ounted ocntrol flie is no ta backu pcontrolf ile.

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

Restorea nd moun ta backu pcontrolf ile.

update : 20-08-2017

ORA-19654 - must use backup control file to switch file incarnations
ORA-19654 - must use backup control file to switch file incarnations

  • ora-13005 : recursive HHCODE function error
  • ora-12434 : invalid audit type: string
  • ora-12681 : Login failed: the SecurID card does not have a pincode yet
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-09813 : Unable to get directory status
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-27376 : event condition cannot be NULL
  • ora-38952 : Source database not compatible
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-15168 : rolling downgrade prevented by string
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-06010 : NETASY: dialogue file too long
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-29290 : invalid offset specified for seek
  • ora-16207 : Logical standby dictionary build not permitted.
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-31398 : DBMS_LDAP: Shared servers are not supported.
  • ora-16548 : object not enabled
  • ora-23374 : object group "string"."string" already exists
  • ora-12611 : TNS:operation is not portable
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-06113 : NETTCP: Too many connections
  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-16170 : Terminal recovery may have left the database in an inconsistent state
  • ora-16157 : media recovery not allowed following successful FINISH recovery
  • 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.