RMAN - start and stop timing for each commands
oracle 11gR2
OS: Linux
I have a RMAN backup script that runs LVL0, LVL1, Archive log backup and maintenance/Cleanup, i.e. crosscheck, delete noprompt expired backup,delete noprompt obsolete, etc.
Question: What do I need to add to this code, so when the maintenance/Cleanup starts, Oracle will indicate start and end time. Just like we add "set time on;" and "set timing on;" in sqlplus. I need to figure out how long each maintenance/Cleanup is running.
Part of the RMAN backup Script:
run {
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F';
# DSRAC-B-01
ALLOCATE CHANNEL LVL0_SBT1_1 DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 100 G