1 create tablespace TS1
2 create restore point RP1;
3 drop tablespace TS1 (datafile '/c:/ts1.dbf') including files
4 restore database to RP1
5 alter database open resetlogs failed with this error :
ERROR at line 1:
ORA-01245: offline file 7 will be lost if RESETLOGS is done
ORA-01110: data file 7: '/c:/ts1.dbf'
Can you help me please to fix this issue and to understand why it's occured.
If you check the alert log you will get message similar to
Recovery deleting file #7:'<Oracle_Home>/db/dbs/UNNAMED00007' from controlfile.
Now you have 2 option
1. If you have backup of that tablespace TS1 then you can restore and recover it
If you don't need that tablespace then you offline drop that datafile 7 . Open the database in resetlogs mode and then drop tablespace TS1