I have several databases that I backup using RMAN and export datapump everynight starting at 6PM and end at Midnight. The backup maintenance window doesn't give me enough time for each database to run at different time. I am using crontab to schedule my backups. Since I have so many databases that need to be backed up between 6PM - Midnight, some of the export and RMAN backup scripts will execute almost at the same time. My question is can my export data pump and RMAN backup scripts run at the same time?
Thank you in advance.
to run both things at the same time will be maybe a Performance impact to the complete system. But i don`t belive that you hot and cold backup in the same time will have a technical impact. I have also some system with your configuration and never a problem with it.
Given the resources that Data Pump uses I believe this is not a good practice and should be avoided if possible.
Run Data Pump on an idle system and then check "top" and you will get an idea how much cpu and memory it is using.
"Data Pump technology fully uses all available resources to maximize throughput and minimize elapsed job time"
Needs must. If you don't run expdp parallel then it doesn't use that much. If it was really killing the system then look into setting up a Resource plan that knocks that user down but this is a big step.
I woud better look into using Rman
system incrementals, and block change tracking, to minimize your RMAN time.
If your shop needs to do both simultaneously then go for it.
PS : One of my shops has maybe 20-30 rmans and pumps all kicking off some simultaneous, some not, from 0000 to 0130. No complaints from users and no problems either. Go for it.
Edited by: Chris Slattery on Nov 25, 2012 11:19 PM