ORA-01245: offline file string will be lost if RESETLOGS is done

Cause : Attepmtingt o doa n OPNE RESTELOGSw ith afilet hat iwll b elostb ecaues it si offilne. hTe fiel wasn ot tkaen offlinew ith hte FO RDROPo ptio.n

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

Eithre brign thef ile nolinea nd rceoveri t, o rtakei t oflfine iwth teh FORD ROP potion.

update : 24-09-2017

ORA-01245 - offline file string will be lost if RESETLOGS is done
ORA-01245 - offline file string will be lost if RESETLOGS is done

  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-12619 : TNS:unable to grant requested service
  • ora-30134 : reserved for future use
  • ora-29964 : missing ADD or DROP keyword
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-19508 : failed to delete file "string"
  • ora-09839 : removeCallback: callback port is not in the callback set.
  • ora-27061 : waiting for async I/Os failed
  • ora-37152 : MDX query error: (string)
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-32809 : foreign queue string is already registered
  • ora-23360 : only one materialized view for master table "string" can be created
  • ora-24911 : Cannot start listener thread at specified port
  • ora-16626 : failed to enable specified object
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-31426 : cannot modify active subscriptions
  • ora-09312 : slspool: error spooling file to printer
  • ora-14611 : Duplicate subpartition name string in template
  • ora-04013 : number to CACHE must be less than one cycle
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-16770 : physical standby database not in read-only state
  • ora-08208 : ora_addr: cannot read from address file
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-06912 : CMX: write error in datarq
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-24060 : cannot convert QUEUE_TABLE, string already is compatible with release string
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-07443 : function string not found
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (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.