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

Question Posted / guest

2 Answers
19908 Views
I also Faced
E-Mail Answers

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