One of my databases is very large. Full exports take 13 hours and hot backups take 8. We do them daily, one after the other without overlap.
But soon, more data will be added and I won't be able to squeeze them both in a single day. Does anybody have any experience with running them at the same time? Some of my tables are quite large, and I am using consistent=Y.
You can adopt round robin tablespace hot backup.
I think you have insufficient hardware ( disk controllers, disks, tapes). If this is the case, first add enough hardware in order to minimize the backup time.
I suggest start using RMAN becuase RMAN will wait for DBWR to complete its work before the data block is copied into backup drive. Do not use your own hot backup script if the DB is huge. That way you can reduce creating many archived redo log files.
Yes, we are going to start using RMAN down the road, but like the hardware, we probably won't be able to implement it before this surge of data hits. we have literally hundreds of databases where I work of all shapes and sizes. we like to keep the backup strategy the same, so going to RMAN is not so easy as it would be if we just had a few databases to work with.
So my questions remain -
Are concurrent hot backups and exports bad because of the fact that consistent exports make a lot of rollback, and when the rollback tablespace is getting hot-backed then there is contention? Is it unsafe or just not good practice?