Long running backups - OK?
Date: Fri, 26 Jan 2018 14:53:34 +0000
Message-ID: <BL2PR05MB235352A201433C4343B782349FE00_at_BL2PR05MB2353.namprd05.prod.outlook.com>
Lively discussion among our team regarding backup run times. We are using RMAN and recently migrated from tape to disk (NFS mounted) based backups. The backups are taking 2-3 times longer (up to 5 times longer when concurrent). Throughput dropped from 200-300mb/sec to 50-70mb/sec. We are investigating the performance issues but the discussion changed to ‘Does it really matter?’
So I wanted to throw out these questions for your opinions. If a database backup is running and not adversely affecting system (and user’s applications’ performance), does it really matter how long it runs?
Are there any negatives to having an Oracle backup run for over x hours? Say a 5 hour (or longer) backup on an active database? What are the ramifications of long-running Oracle database backups, if any?
Note we have dozens of databases over 1tb and run fulls weekly, cumulatives (inc level 1) daily, archivelogs hourly.
I just can’t deal with a backup running for a quarter of the day. Seems to be a long window of exposure and vulnerability should a crash occur.
Thoughts?
Glenn Travis
DBA ▪ Database Services
IT Enteprise Solutions
SAS Institute
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 26 2018 - 15:53:34 CET