| 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? | |
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