ORA-19631: archivelog record contains no file name

Cause : This archivelog record represents a switch into an active log that took place without archiving its prior contents. The prior contents of the log file are lost.

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

Specify the recid of an archivelog record that contains a file name. Fixed view v$archived_log can be used to examine the archived logs.

update : 25-06-2017
ORA-19631

ORA-19631 - archivelog record contains no file name
ORA-19631 - archivelog record contains no file name

  • ora-19915 : unable to encrypt pre-10.2 files
  • ora-38414 : invalid datatype for the attribute string
  • ora-09954 : scgcc: unexpected return status to callback of lock close
  • ora-12729 : invalid character class in regular expression
  • ora-29817 : non-supported option with disassociate statement
  • ora-01936 : cannot specify owner when creating users or roles
  • ora-09976 : skxfqdini: Error Creating Port
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-30100 : internal error [number]
  • ora-12619 : TNS:unable to grant requested service
  • ora-24402 : error occured while creating connections in the pool
  • ora-13433 : GeoRaster metadata default RGB error
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-12923 : tablespace string is in force logging mode
  • ora-13197 : element string.string.string is out of range
  • ora-22977 : missing or invalid attribute
  • ora-31659 : status message was invalid type - detaching job
  • ora-14086 : a partitioned index may not be rebuilt as a whole
  • ora-16559 : out of memory at string
  • ora-10664 : Table has bitmap join indexes
  • ora-23542 : dependent object "string"."string" already registered
  • ora-28350 : cannot encrypt the specified column recorded in CDC synchronized change table
  • ora-09756 : osnpns: no port in the name server.
  • ora-16548 : object not enabled
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • 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.