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-25126: Invalid name specified for BUFFER_POOL

1 Answers  


NCR-04017: NCRR: Unable to find the interface instance handle

1 Answers  


ORA-00250: archiver not started

1 Answers  


display details of employee's who are seniour to there own manager ? ( In a Emp Table )

2 Answers  


ORA-16801: Some log transport related property is inconsistent.

1 Answers  






ORA-15072: command requires at least string failure groups, specified only string

1 Answers  


ORA-26077: direct path column array is not initialized

0 Answers  


ORA-01002: fetch out of sequence

1 Answers  


RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string

1 Answers  


SQL-02103: Inconsistent cursor cache. Out of range cursor cache reference

1 Answers  


SQL-02120: First and second arguments to SQLRCN both null

1 Answers  


ORA-24508: Buffer is not aligned correctly.

1 Answers  


Categories