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 CHECKSYNTAX
  • Using the DEBUG option
  • I/O modes and their impact on RMAN
  • Memory management related to RMAN
  • Monitoring RMAN
  • Using tracing ...

Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial