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-16521: unable to create generic template id

1 Answers  


ORA-00311: cannot read header from archived log

1 Answers  


ORA-22951: NULL returned by ORDER method

1 Answers  


DRG-51025: an invalid character was passed to the stemmer

1 Answers  


RMAN-00601: fatal error in recovery manager

1 Answers  






ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.

1 Answers  


PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

1 Answers  


ORA-07257: spdcr: translation error expanding program name.

2 Answers  


ORA-32152: Cannot perform operation on a null number

1 Answers  


SQL*Loader-00134: invalid option specified for EXTERNAL_TABLE parameter

1 Answers  


ORA-12690: Server Authentication failed, login cancelled

1 Answers  


ORA-04061: existing state of string has been invalidated

1 Answers  


Categories