ORA-38732: Expected file size string does not match string.

Cause : The file size indicated in the control file did not match the file size contained in the flashback log file header. The flashback database log file was corrupt.

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

If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.

update : 24-05-2017
ORA-38732

ORA-38732 - Expected file size string does not match string.
ORA-38732 - Expected file size string does not match string.

  • ora-06131 : NETTCP: user access denied
  • ora-01931 : cannot grant string to a role
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-12570 : TNS:packet reader failure
  • ora-28001 : the password has expired
  • ora-02376 : invalid or redundant resource
  • ora-03007 : obsolete feature
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-08234 : smsget: cannot get instance listener address
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-00132 : syntax error or unresolved network name 'string'
  • ora-22922 : nonexistent LOB value
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-19686 : SPFILE not restored due to string
  • ora-30976 : invalid Parent Order Key Index option for XML Index
  • ora-02795 : Request list is empty
  • ora-13156 : table to be registered string.string is not empty
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-12654 : Authentication conversion failed
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-19041 : Comment data cannot contain two consecutive '-'s
  • ora-22293 : LOB already opened in the same transaction
  • ora-27049 : unable to seek to and read the last block
  • ora-01554 : out of transaction slots in transaction tables
  • 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.