RMAN "SWITCH" COMMAND TAKING A LONG TIME (Doc ID 1391847.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Symptoms

The RMAN SWITCH command ws taking a long time.

After enabling RMAN client debug tracing, it was seen that the majority of the time was being spent in the call to sys.dbms_backup_restore.switchToCopy().
Server-side tracing of the RMAN default process showed that the time was being spent doing many controlfile reads:



begin sys.dbms_backup_restore.switchToCopy( copy_recid => :recid, copy_stamp => :stamp); end;

call    count  cpu    elapsed disk query current rows
------- ------ ------ ------- ---- ----- ------- ----
Parse        1   0.00    0.00    0     0       0    0
Execute      1   0.24   22.26    0     0       0    1
Fetch        0   0.00    0.00    0     0       0    0
------- ------ ------ ------- ---- ----- ------- ----
total        2   0.24   22.26    0     0       0    1
...
Elapsed times include waiting on following events:
Event waited on              Times  Max. Wait  Total Waited
---------------------------- Waited ---------- ------------
control file sequential read   4910       0.02        22.02

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.