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

RMAN-06128: skipping inaccessible file string

1 Answers  


ORA-24803: illegal parameter value in lob read function

1 Answers  


ORA-23430: argument "string" cannot be NULL or empty string

2 Answers  


NNL-00936: Requests refused, DATA-EXISTS violation: number

1 Answers  


ORA-02221: invalid MAXEXTENTS storage option value

1 Answers  






NNL-00559: Shows, sets, or cancels the time for the next cache dump to the trace file

1 Answers  


ORA-30360: REF not supported with query rewrite

1 Answers  


LPX-00251: conditional sections are valid only in external DTDs

1 Answers  


UDI-00011: parameter string is incompatible with parameter string

1 Answers  


LPX-00257: invalid children specification in element declaration

1 Answers  


ORA-14072: fixed table may not be truncated

1 Answers  


CLSR-06507: Cannot add to SERVICE_NAMES, SERVICE_NAMES will be too long

1 Answers  


Categories