Database Backup and Recovery (MOSC)

MOSC Banner

Drop tablespace and flashback : ORA-01245: offline file 7 will be lost if RESETLOGS is done

edited Aug 15, 2013 3:33AM in Database Backup and Recovery (MOSC) 1 commentAnswered ✓
Hello,  I need your help to resolve a problem occur after flashback and open resetlogs;

Scenario :

   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.
 
  it's Ok for me if i lose the file 7
  Best Regards
 
  Dj

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center