Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20594 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-08102: channel string: located backup piece: string
NNL-00345: Save_config_on_stop is currently OFF
ORA-26031: index maintenance error, the load cannot continue
ORA-19642: incremental-start SCN is string
RMAN-08086: replaced script string
ORA-19323: Invalid url string
ORA-26049: Unscoped REF column has non-existent table name.
ORA-02314: illegal use of type constructor
ORA-15066: offlining disk "string" may result in a data loss
ORA-12062: transaction string received out of sequence from site string
NNL-01032: Minimum TTL: string
ORA-12319: database (link name string) is already open
Oracle Errors 
