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 : 27-04-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-39162 : Transportable tablespace job require privileges
  • ora-00217 : control file could not be resized for new record types
  • ora-13797 : invalid SQL Id specified, string
  • ora-39763 : stream must be completely loaded before it is reset
  • ora-12017 : cannot alter primary key mview 'string' to a rowid mview
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-27202 : skgfpen: sbtpcend returned error
  • ora-03129 : the next piece to be inserted is required
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-16100 : not a valid Logical Standby database
  • ora-01525 : error in renaming data files
  • ora-19031 : XML element or attribute string does not match any in type string.string
  • ora-39146 : schema "string" does not exist
  • ora-13610 : The directive string does not exist for task string.
  • ora-28031 : maximum of string enabled roles exceeded
  • ora-13303 : failure to retrieve a geometry object from a table
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-07265 : sppst: semop error, unable to increment semaphore.
  • ora-15060 : template "string" does not exist
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-25465 : variable name not specified
  • ora-02214 : duplicate BACKUP option specification
  • ora-09805 : conversion of category number to string failed.
  • ora-29353 : The transportable list is too long.
  • ora-28172 : distinguished name not provided by proxy
  • ora-31038 : Invalid string value: "string"
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • ora-06754 : TLI Driver: unable to get local host address
  • 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.