开发者

Backup Time reduction question

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 开发者_StackOverflow中文版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


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜