Database Backup and Recovery (MOSC)

MOSC Banner

RMAN - start and stop timing for each commands

edited Sep 3, 2014 5:26PM in Database Backup and Recovery (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center