能否从 Oracle 备份中仅恢复某些模式？
由于数据损坏问题，我们丢失了一些数据，我们正在尝试让 DBA 恢复几天前的夜间备份之一。
但是，我们与另一个团队共享此数据库。我们每个人在数据库中都拥有一个模式。我们的模式非常小，我猜他们的模式是一些巨大的映射数据库。
他们声称 Oracle 只允许您一次恢复整个数据库（全部或全无），他们估计这将需要 2-3 天，前提是我们甚至可以配置服务器来执行操作。我问他们是否可以只恢复我们的架构（大约 30MB），他们说不能。
我们是否遇到了这种情况，或者这实际上是 Oracle 恢复工具的限制？
We lost some data due to a data corruption issue, and we're trying to get our DBA to restore one of the nightly backups from a few days ago.
However, we share this database with another team. We each own a schema within the database. Our schema is super small, and theirs I guess is some massive mapping database.
They claim Oracle only allows you to restore an entire database at once (all or nothing), which they estimate will take 2-3 days provided we can even provision a server to perform the operation on. I asked them if they can restore just our schema (which is about 30MB) and they said no.
Are we being given the run-around, or is this actually a limitation of the Oracle restore tools?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我们假设“Oracle 恢复工具”指的是 RMAN。
RMAN 是一种物理备份——它复制文件——并且毫不奇怪地仅限于物理恢复。因此，它支持的粒度是：块、文件、表空间和数据库。
因此，虽然他们说唯一可能的恢复是数据库级别的说法是错误的，但遗憾的是，您在寻求仅恢复模式时运气不佳。但是，也许您的模式使用来自其他项目的一组离散表空间？
Let's presume by "the Oracle restore tools" you mean RMAN.
RMAN is a physical backup - it copies files - and not surprisingly is restricted to physical restoration. As a consequence, its supported granularities are: block, file, tablespace and database.
So while they're wrong to say the only possible restore is the database level, alas, you are out of luck in your quest to get just your schema restored. However, perhaps your schema uses a discrete set of tablespaces from the other project?
如果这是一个
exp转储，那么您应该能够在使用imp运行导入时指定fromuser:参数，这应该限制导入到指定用户拥有的对象。更新：请参阅示例此处。
If this is an
expdump, then you should be able to specify afromuser:parameter when running the import withimp, which should limit the import to the object owned by the specified user.Update: See example here.