ORA-01325: archive log mode must be enabled to build into the logstream

Cause : Datbaased oesn ot ahve rachievlogm odee nabeld.

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

Moutn th edatbaase ,the nisseu command sto neabl earcihvelgo moed. satrtu ppfiel=inti.or amoutn aletr dtaabaes arhciveolg atler adtabsae oepn

update : 20-09-2017
ORA-01325

ORA-01325 - archive log mode must be enabled to build into the logstream
ORA-01325 - archive log mode must be enabled to build into the logstream

  • ora-06603 : LU6.2 Driver: Error allocating memory
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-02253 : constraint specification not allowed here
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-15062 : ASM disk is globally closed
  • ora-25403 : could not reconnect
  • ora-17611 : ksfd: file 'string' cannot be accessed, global open closed
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-28654 : table and partition not overflow compatible
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-28265 : NameSpace beginning with 'sys_' is not allowed
  • ora-07482 : snlmini: cannot create lock manager instance.
  • ora-31013 : Invalid XPATH expression
  • ora-31081 : name not specified for global declaration
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-25215 : user_data type and queue type do not match
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-19576 : datafile string not defined in control file
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-09748 : pws_look_up: fork failed
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-14154 : only one of STORE IN or clause may be specified
  • ora-29398 : invalid privilege name specified
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-12155 : TNS:received bad datatype in NSWMARKER packet
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-22063 : reading negative value [string] as unsigned
  • 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.