Database Utilities (MOSC)

MOSC Banner

RMAN controlfile autobackup takes too long

edited Dec 10, 2012 4:09PM in Database Utilities (MOSC) 5 commentsAnswered
Hi.
I'm using RMAN (11.1.0.7 on Oracle Enterprise Linux 5.6) to backup DB to Oracle Secure Backup (via SBT channel). My script is very simple:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
LIST BACKUP SUMMARY DEVICE TYPE 'sbt';
REPORT OBSOLETE DEVICE TYPE 'sbt';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
DELETE NOPROMPT OBSOLETE DEVICE TYPE='sbt';
RELEASE CHANNEL;
LIST BACKUP SUMMARY DEVICE TYPE 'sbt';
run {
   allocate channel C1 device type sbt;
   backup filesperset 4 incremental level 0 database;
   sql "alter system switch logfile";
   backup archivelog all delete all input;
   backup current controlfile;
   release channel C1;
}

rman shows this configuration:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default

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