Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

backup recommendation

jdiApr 2 2009 — edited Apr 3 2009
Hi

Version 10.2.0.3

We have a db of 200GB size. Most of the data in the db changes on a daily basis. Our business requires the db to be recovered to a most recent time. At the moment we have taking rman full backup daily at 4pm which usually ends by morning next day morning 6am.We stored only the recent backupset (new backupset will replace the older one). The archivelogs & backupsets are stored in a san mount. A script deletes the archive log older than 2 days. Before it used to run in 14 hours but nowadays it takes around 30 hrs or more to run a backupset. I get around 1.62M in INPUT_BYTES_PER_SEC_DISPLAY & OUPUT_BYTES_PER_SEC_DISPLAY from v$rman_backup_job_details view. Could someone suggest me to speed up the backup process? thanks

cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2009
Added on Apr 2 2009
16 comments
1,517 views