Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20761 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 |
ORA-27198: skgfpvl: sbtpcvalidate returned error
ORA-30772: opaque types do not have default constructors
PCC-02435: This attribute is only valid for internal LOB types
PCC-02203: found end of file when not expected
ORA-10561: block type 'string', data object# string
RMAN-06492: controlfile autobackup format "string" must specify a "string" format specifier
ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
DRG-12402: error processing template string, line string
ORA-01764: new update value of join is not guaranteed to be unique
ORA-25237: navigation option used out of sequence
ORA-27049: unable to seek to and read the last block
RMAN-10029: unexpected return code number from PL/SQL execution
Oracle Errors 
