Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20578 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-06099: error occurred in source file: string, line: number
PLS-00407: '*' not allowed here; a list of columns is required
ORA-26085: direct path operation must start its own transaction
ORA-31466: no publications found
ORA-27414: Invalid BY value type
ORA-01913: EXCLUSIVE keyword expected
KUP-04015: internal SLF error
QSM-02017: subquery present in the HAVING clause
ORA-31622: ORACLE server does not have string access to the specified file
NNL-00897: Messages sent: number
ORA-15104: conflicting CONTENTS options
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
Oracle Errors 
