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? |
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
最后修改时间：2020-04-16 15:13:22
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
