Robert,

Are you using the Oracle Recovery catalog?  There are a number of
performance issues related to the recovery catalog that will slow down your
backups (we had similar issues here) over a period of time depending on how
many datafiles for each backup.  If you have access to Metalink you should
be able to find many examples of which most of them probably will tell you
to migrate your oracle database to 9i (9.2).  Even with the Oracle 9.2
recovery catalog there are performance issues.

Try adding these indexes to the recovery catalog schema:

create index bs_i_1 on bs (db_key, bs_recid, bs_stamp); 
create index db_i_2 on bp (db_key, bp_recid, bp_stamp); 

Also calculating stats on the recovery catalog schema will help performance
as well. We recalc the stats daily using
dbms_utility.analyze_schema(''RMAN'',''COMPUTE''); (assuming that RMAN is
the recovery catalog owner) and it helps a lot.

Hope that helps!!

Mike Leary
Oracle DBA / Data Architect
Managed Security Services
TruSecure Corporation
678.728.1000
mleary AT trusecureonline DOT com
www.trusecure.com



-----Original Message-----
From: Robert C Metcalf [mailto:metrobb AT world.std DOT com]
Sent: Monday, January 05, 2004 3:59 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Oracle RMAN backup window increases


Netbackup 4.5, MP5, Oracle RMAN extension...

Oracle 8.17

What begins as a three hour duration backup for the
database slowly increases in duration, 10-15 minutes
a day, until we're pushing seven hours.  No appreciable
increase in the amount of data being backed up, although
the size of the backup is substantial.

Bouncing the database server procs seems to reset us back
to "normal" duration.

Any ideas?

Thanks.
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu