RE: Long running backups - OK?

Hi Glenn,

It doesn’t matter how long the backup takes. ;-) The important part is how long it takes to restore and recover when you need to. If you haven’t already done so, you should test the restore and recover to make sure it meets the business’ requirements.

Bob Stauffer
DBA/Database Developer
IT Database Production Support
rstauffer_at_fult.com
(717) 327-2646 x10646
FULTON FINANCIAL CORPORATION
1695 State Street
East Petersburg, PA 17520

We will care, listen, understand and deliver. That’s our promise!

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Glenn Travis Sent: Friday, January 26, 2018 9:54 AM
To: oracle-l_at_freelists.org
Subject: Long running backups - OK?

This message is from an external source. Please use caution when opening links and attachments.

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

***CONFIDENTIALITY NOTICE***This email contains confidential information which may also be legally privileged and which is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that forwarding or copying of this email, or the taking of any action in reliance on its contents, may be strictly prohibited. If you have received this email in error, please notify us immediately by reply email and delete this message from your inbox. Thank you. E-Mail Opt Out Notice: This e-mail message may include an advertisement. You have the right to request that we not send future advertisements to you at this e-mail address. If you prefer not to receive future advertisements from us at this e-mail address, please access the following url http://www.optoutffc.com/ Fulton Financial Corporation, P.O. Box 4887, Lancaster, Pa. 17604

--
http://www.freelists.org/webpage/oracle-l