Begin backup takes a long time
All,
Database- 9206
OS - Sun solaris 64bit, 5.8
We have a 4tb database with 64 tablespaces, 896 datafiles, putting this database in backup mode using alter tablespace begin backup commands would take 20 to 25 mins. Lately, it is taking over 2 hrs.
The only change before this unusually big difference was we moved to locally managed temporary tablespaces. I don't think this contributes in any way, but that was the only change on the database.
We tried different backup times, but still the same result.
I don't know what/where to start looking for this problem.
Greatly appreciate all your suggestions.
Regards
Vj