Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman backup taking twice as long

Mike1255Sep 6 2016 — edited Sep 13 2016

I have a 16 TB database on an AIX server, power 7 running Oracle 12c and do an online level 0 backup once a week and level 1 incremental backups 5 times a week.  I normally use OEM to setup and schedule my backups bu have been having problems with OEM so I've been doing them manually with the code I copied from OEM.

The level 0 backups usually take about 40 hours but 2 weeks ago it took 5 days and the one started this weekend has been running for 3 days and is still running.

I've been looking on the web for ways to troubleshoot the problem but haven't found much.  If anyone has suggestions of where I can start looking, I would greatly appreciate it.

Here's the script I've been running:

backup incremental level 0 cumulative device type disk tag '%TAG' database;

backup device type disk tag '%TAG' archivelog all not backed up delete all input;

allocate channel for maintenance type disk;

delete noprompt obsolete device type disk;

release channel;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2016
Added on Sep 6 2016
18 comments
6,760 views