Diagnose the cause of slow mongolerman backup

(I) First query the CPU and IO usage at the system level: top, iostat, sar... (ii) EXECDBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); (iii) rmanta

(I) First query the CPU and IO usage at the system level: top, iostat, sar... (ii) EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); (iii) rman ta

(I) First query the CPU and IO usage at the system level: top, iostat, sar...

(Ii) EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();

(Iii) rman target/debug trace =/tmp/rmandebug.txt log =/tmp/rman_log20130727.txt

Execute backup

(Iv) EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();

(V) query v $ backup_datafile

Set markup html on
Set echo on
Set pages 80
Set lines 180
Set NUMFORMAT 99999999999999999
Spool rman_bak20130727.html
Select file # fno, used_change_tracking bct, incremental_level incr,
Incremental_change #, checkpoint_change #, datafile_blocks blks,
Block_size, blocks_read, round (blocks_read/datafile_blocks) * 100,2) "% READ ",
Blocks, round (blocks/datafile_blocks) * 100,2) "% WRTN ",
To_char (comletion_time, 'yyyy-mm-dd hh24: mi: ss ')
From v $ backup_datafile
Order by file #, comletion_time;
Spool off
Set markup html off

Recommended reading:

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

,