Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20596 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 |
RMAN-06446: changed proxy copy unavailable
ORA-16596: object not part of the Data Guard broker configuration
LPX-00262: unsupported protocol ~s
ORA-32164: Method called on Invalid Connection type
ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context
ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response
TNS-00501: Cannot allocate memory
PLS-00990: Index Tables of Cursor Variables are disallowed
ORA-02182: savepoint name expected
ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR
ORA-03242: Tablespace migration retried 500 times
Oracle Errors 
