ORA-00308: cannot open archived log 'string'

Cause : The system cannot access a required archived redo log file.

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

Check that the off line log exists, the storage device is online, and the archived file is in the correct location. Then attempt to continue recovery or restart the recovery session.

update : 26-05-2017

ORA-00308 - cannot open archived log 'string'
ORA-00308 - cannot open archived log 'string'

  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • ora-13337 : failure in concatenating LRS polygons
  • ora-28138 : Error in Policy Predicate
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-13453 : GeoRaster metadata layer error
  • ora-16569 : Data Guard configuration is not enabled
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-19010 : Cannot insert XML fragments
  • ora-25467 : table alias not specified
  • ora-27103 : internal error
  • ora-33262 : (DBERR01) Analytic workspace string does not exist.
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-31195 : XML node 'string' (type=string) does not support this operation
  • ora-12448 : policy string not applied to schema string
  • ora-31434 : purge is currently running
  • ora-31460 : logfile location string is not an existing directory
  • ora-01236 : Error string occurred during initialization of file header access
  • ora-31654 : unable to convert file or volume size as specified to a number
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-09959 : IMON: deletion of a process failed.
  • ora-28502 : internal communication error on heterogeneous database link
  • ora-16745 : unable to add DB_UNIQUE_NAME string into the DG_CONFIG list because it is full
  • ora-16720 : no LOG_ARCHIVE_DEST_n initialization parameters available
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • 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.