O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring RMAN sessions and operations

As RMAN performs the tasks using the channels which work by maintaining a session within the database as any other normal user session, it's easy to track its working using the standard database views V$SESSION and V$PROCESS. Using these two views together, we can identify the server processes that are used by RMAN channels and use that information for performance bottleneck troubleshooting as we would do for a normal database session, for example, by enabling tracing on it.

The easiest way to find information about the System ID (SID) of the channel is to look at the RMAN prompt. For example, the following is a partial output from a backup command:

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=55 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required