The Oracle (tm) Users' Co-Operative FAQ

How to Recover a Datafile that Belongs to READ-ONLY Tablespace


Author's name: Allan W. Tham

Author's Email: allanwtham@hotmail.com

Date written: Feb 8 2002

Oracle version(s): 8.1.7.0.0

I lost a datafile that belongs to READ-ONLY tablespace, how do I recover it?

Back to index of questions


To recover a loss datafile that belongs to READ-ONLY tablespace is an easy task indeed. Since READ-ONLY tablespace is never modified, simply restore the datafile to its original location shall do the job. However, if you change from read-only to read-write vice-versa since last backup, you have to restore the file and do a media recovery on it.

     Svrmgrl> Recover datafile xxx 

Apply the logs until you see "Media Recovery Complete"


Further reading: Metalink Note:1013129.6 and 94114.1


Back to top

Back to index of questions