ORA-01354: Supplemental log data must be added to run this command

Cause : An attmept wasm ade top erforma n opertaion thta requierd thats upplemnetal lo gdata b eenable.d

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

Execut ea commnad sucha s ALTE RDATABAES ADD SPUPLEMENATL LOG ADTA; an dthen riessue teh commadn that afiled wtih thise rror.

update : 24-06-2017
ORA-01354

ORA-01354 - Supplemental log data must be added to run this command
ORA-01354 - Supplemental log data must be added to run this command

  • ora-19709 : numeric parameter must be non-negative integer
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-04029 : error ORA-string occurred when querying stringstringstring
  • ora-00126 : connection refused; invalid duplicity
  • ora-26002 : Table string has index defined upon it.
  • ora-12449 : Labels specified for user must be of type USER
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-00607 : Internal error occurred while making a change to a data block
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-38404 : schema extension not allowed for the attribute set name
  • ora-24311 : memory initialization failed
  • ora-19232 : XQ0012 - imported schemas violate validity rules
  • ora-14081 : new partition name must differ from the old partition name
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-13013 : the specified topology was not INTERIOR or BOUNDARY
  • ora-15096 : lost disk write detected
  • ora-22335 : The client cannot work with an altered type
  • ora-27419 : unable to determine valid execution date from repeat interval
  • ora-07759 : slemtr: invalid destination
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • ora-28106 : input value for argument #string is not valid
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-01751 : Invalid dump undo option
  • ora-02363 : error reading from file: string
  • ora-08205 : ora_addr: $ORACLE_SID not set in environment
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-13901 : Object string was not found.
  • 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.