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 : 23-07-2017
ORA-01245

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-29256 : Cursor contains both regular and array defines which is illegal
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-24101 : stopped processing the argument list at: string
  • ora-25154 : column part of USING clause cannot have qualifier
  • ora-01754 : a table may contain only one column of type LONG
  • ora-28558 : HS_FDS_CONNECT_STRING undefined for non-Oracle system
  • ora-13772 : unexpected deadlock on "SQL Tuning Set" "string" owned by user "string"
  • ora-02763 : Unable to cancel at least one request
  • ora-27035 : logical block size is invalid
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-02143 : invalid STORAGE option
  • ora-01227 : log string is inconsistent with other logs
  • ora-13337 : failure in concatenating LRS polygons
  • ora-08177 : can't serialize access for this transaction
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-30156 : Out of disk space
  • ora-24089 : AQ Agent string already exists
  • ora-24001 : cannot create QUEUE_TABLE, string already exists
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-37179 : expected at least one column for dimension string, got 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.