It is suggested to routine Oracle data source copy at non pick hours. This thing cannot done stringently to those companies or sites, which are running 24/7 and available worldwide. During copy, efficiency of data source might lower. Performance effect will depend on size data source and number of contingency classes. |
If hot copy is taken during non pick hours then it definitely will depend on dimension data source as well as copy location. If you take back-up in the area and put copy in same disk where production data source located then during copy, efficiency of data source surely changed. If you take back-up at NAS then efficiency of copy might degrade because copy definitely will depend on network bandwidth. If dimension data source is large then active of bandwidth will be using and operation of copy can become slower.
If you are backing up data source using upload application then efficiency badly affected of server because upload application can consume more resource of CPU and memory. If during upload, sessions are trying to get report or efficiency multiple deal then efficiency of data source surely affected.
RMAN is good copy application of Oracle. Using RMAN you can take copy similar but during this similar function high source of host will be employing. If data source used by classes worldwide and at the time of RMAN function, classes are trying to access data source then efficiency horribly affected.
In 24/7 operating data source, it is not easy to maintain copy easily because data source is being utilized by multiple session worldwide at anytime from anywhere. Duplicating data source for support up data source function is totally depending on dimension computer file and dimension data source. If data source is larger in dimension then it would take more time to finish as well source of host would take effect. During support up data source, if any deal is occurring or any long term query is implemented then data source badly impact of efficiency bottleneck. During Hot copy process, high numbers of store files are generated this function also functions host read in the area. If more than single store destination designed in data source then store function also takes so much system source. Finally result would be efficiency degrading of host.
In new datapump function, we can perform upload similar. This similar function will eat high source at host level and efficiency can be impacting. I have seen so many accidents about copy process either trapped or operating long and very next day also operating at choose hours.
Author is having 15+ years experience and providing Database Services and, Oracle DBA Interview Questions book.
Related Articles -
oracle tuning, oracle performance tuning, Oracle backup recovery,