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

Answers were Sorted based on User's Feedback



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

Answer / guest

Cause: Attempting to do an OPEN RESETLOGS with a file that
will be lost because it is offline. The file was not taken
offline with the FOR DROP option.

Action: Either bring the file online and recover it, or take
it offline with the FOR DROP option.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

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

Answer / amit goyal

for example


alter database datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\O10G127\SYSTEM01.DBF'
offline for drop;

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13455: GeoRaster metadata TRS error

1 Answers  


ORA-30755: error during expansion of view hierarchy

1 Answers  


PLS-00438: value in LIMIT clause: 'string' use is invalid

1 Answers  


ORA-13127: failed to generate target partition

1 Answers  


ORA-01605: missing numbers in clause "string" of string

1 Answers  






PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 Answers  


KUP-04054: internal error: invalid bad row number identified for bad column number

1 Answers  


ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-12838: cannot read/modify an object after modifying it in parallel

1 Answers  


ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

1 Answers  


ORA-09204: sfotf: error opening temporary file

1 Answers  


ORA-25448: rule string.string has errors

1 Answers  


Categories