ORA-16007: invalid backup control file checkpoint

Cause : The abckupc ontrlo fil ebein gopende forr ead-noly access odes nto conatin av alidc ontrlo fil echecpkoint .Therfeore hte daatbasec anno tbe oepned ofr reda-onl yaccess.

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

Firs topent he dtaabas efor erad-wirte access hwich iwll rseult ni valdi conrtol flie chcekpoitn. Thne re-poen teh datbaase ofr reda-onl yaccess.

update : 30-04-2017
ORA-16007

ORA-16007 - invalid backup control file checkpoint
ORA-16007 - invalid backup control file checkpoint

  • ora-06027 : NETASY: channel close failure
  • ora-01160 : file is not a string
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-26674 : Column mismatch in 'string.string' (LCR: string type=string; DB: string type=string)
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-19593 : datafile number string already included as string
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-02757 : osnfop: fork_and_bind failed
  • ora-16729 : validation of value for property string found string error
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-13378 : invalid index for element to be extracted
  • ora-29513 : referenced class name too long
  • ora-36691 : (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • ora-01040 : invalid character in password; logon denied
  • ora-24786 : separated transaction has been completed
  • ora-19624 : operation failed, retry possible
  • ora-16129 : unsupported dml encountered
  • ora-24202 : publisher does not exist for the queue
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-31088 : object "string"."string" depends on the schema
  • ora-22336 : table contained 8.0 image format, must specify INCLUDING DATA
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-25001 : cannot create this trigger type on views
  • ora-27094 : raw volume used can damage partition table
  • ora-32591 : connect string too long
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • 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.