Chapter 8. RMAN Troubleshooting and Tuning
When it comes to any tool or utility, there are inevitably going to be aspects related to them. One, it is always expected that the tool must perform at its best; and two, whenever there is any issue with the tool, we should be able to troubleshoot and resolve it easily. A DBA looks forward to the same with RMAN as well. Therefore, in this chapter, our objective is to look at the various ways to get the best performance from RMAN and also learn some techniques to troubleshoot it when it acts mischievously.
Throughout the chapter, we will be discussing the following topics:
Using
CHECKSYNTAXUsing the
DEBUGoptionI/O modes and their impact on RMAN
Memory management related to RMAN
Monitoring RMAN
Using tracing for RMAN performance tuning
