Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Back out of OFFLINE DROP

S.BovinJan 13 2010 — edited Jan 13 2010

After doing an OFFLINE DROP, is it possible to get the datafile back online
or do we have to recover the file from backups ?

We did this ...

   ALTER DATABASE DATAFILE '<file>'  OFFLINE DROP;

At this point the physical data files exists and the file is still visible in V$DATAFILE and DBA_DATAFILES as follows

V$DATAFILE Status = RECOVER
DBA_DATA_FILES Status = AVAILABLE Online Status = RECOVER

At this point, attempts to make the datafile online fail

   ALTER DATABASE DATAFILE '<file>'  ONLINE;
   
   ORA-01113: file 15 needs media recovery
   ORA-01110: data file 15: '<file>'

Is it possible to get the datafile back online ?
Are there any issues ? Do I have to mount the database in a particular mode to do this ?

Environment - RDBMS 10.2.0.4.0, HP-UX

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2010

Added on Jan 13 2010

#general-database-discussions

10 comments

1,199 views