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 : 23-08-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-25110 : NOSORT may not be used with a bitmap index
  • ora-01036 : illegal variable name/number
  • ora-31638 : cannot attach to job string for user string
  • ora-22307 : operation must be on a user-defined type
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-04066 : non-executable object, string
  • ora-32631 : illegal use of objects in MODEL
  • ora-02158 : invalid CREATE INDEX option
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-25501 : ALTER SYSTEM QUIESCE RESTRICTED command failed
  • ora-22152 : destination variable-length array is not initialized
  • ora-01677 : standby file name convert parameters differ from other instance
  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-06314 : IPA: Event set up failure
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-26691 : operation not supported at non-Oracle system
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-39044 : Metadata transform string has already been specified.
  • ora-23602 : Invalid streams process type string
  • ora-31416 : invalid SOURCE_COLMAP value
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-02771 : Illegal request time out value
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-30179 : invalid argument index used in a format code
  • ora-16108 : database is no longer a standby database
  • ora-23448 : duplicate user parameter value
  • ora-13185 : failed to generate initial HHCODE
  • ora-01510 : error in deleting log files
  • 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.