ORA-01245: offline file string will be lost if RESETLOGS is done
Answers were Sorted based on User's Feedback
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 |
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 |
DRG-10841: invalid SCORE argument supplied to FUZZY
NNC-00002: error listening on stream string
ORA-13341: a line geometry has fewer than two coordinates
QSM-02048: outer join in mv
TNS-01039: %s has string service handler(s)
NZE-28768: bad magic number
SQL*Loader-00654: Variable length field exceeds maximum length.
ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
ORA-02068: following severe error from stringstring
RMAN-08591: WARNING: invalid archivelog deletion policy
ORA-23462: flavor string in use at site string
ORA-29300: ORACLE error, tablespace point-in-time recovery