减少备份时间的问题
据我所知，在 ORACLE 10g 中，数据库大小 65GB 的完整数据库备份需要 4-5 小时。 这正常吗？
我们有一个单独的计划活动，大约需要 1.5 小时。 我们需要在单个会话中执行完整备份和此程序活动，这意味着 完成整个训练需要 5 + 1.5 = 6.5 小时。 但我们最多有 5 小时的活动变化窗口。
问题 1）ORacle 10g 中是否有另一种方法可以备份数据库中发生的增量更改 （但我们不知道数据库中哪些表被更新以专门备份）之间 2天？如果是这样，我们该怎么做？ 2）是否可以轻松导入该数据库中那些增量更改的表以减少 备份时间？如果是这样，我们该怎么做？
谢谢
I am told that a full DB backup of DB size 65GB takes between 4-5hrs in ORacle 10g.
Is that normal ?
We have a separate program activity that would take about 1.5 hrs.
We need to perform a full backup and this program activity in a single session which means
5 + 1.5 = 6.5 hrs needed to perform this whole session.
But we are given a maximum of 5-hr activity change window.
Question
1) Is there another way in ORacle 10g where we could backup the delta change occurred a DB
(but we dont know which tables are updated in the DB to backup specifically) between
2 days ? If so, how do we do it ?
2) Would it be easy to import those delta-changed tables in that DB in order to reduce the
backup time ? If so, how do we do it ?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
事实上我见过65G的数据库甚至需要10个小时。备份是一种高度可调的介质。
备份率取决于许多因素，包括备份到的介质。设置即 rman 与非 rman 。磁盘与磁带。如果您可以在您的问题中添加更多事实。一个答案是可能的。
此外，Oracle 10g 在备份领域引入了大量优化，例如块更改跟踪文件和恢复为。
详细信息可以在 Oracle 10.2 备份和恢复中找到。恢复指南
查看增量策略以及调整备份区域。
Actually i have seen 65G database take even 10 hrs. Backups are a very highly tunable medium.
the Backup rate depends on many factors including the medium its being backed up to . the setup i.e rman vs non rman . disk vs tape . if you can add a little more facts to your questions. a answer can be possible .
Also Oracle 10g Introduced a plethora of optimizations in the backup area like the Block change tracking file and the recover as.
Details can be found in Oracle 10.2 Backup & Recover Guide
Look at the incremental strategy as well as tuning backups area.