Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20451 Views
- I also Faced
- E-Mail Answers
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 |
NNL-00540: [show] status [<server_list>] : display server status summary
RMAN-20222: datafilename not found in recovery catalog or is ambiguous
RMAN-04020: target database name "string" does not match channel's name: "string"
NPL-00411: incoming ASN.1 NULL encoding has nonzero length of string
RMAN-06058: a current controlfile cannot be included along with a standby controlfile
DRG-50943: query token too long on line string on column string
DRG-10844: index cannot execute this structured predicate efficiently
ORA-25408: can not safely replay call
ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based
ORA-36881: (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.
ORA-09743: smscre: could not attach shared memory.
PLS-00568: cannot access rows from a non-nested table item
Oracle Errors 
