| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup policy
I approach the issue from the point of view that the database should be
up. If it is not up, my last backup plus archives is available.
Also, if it is not up and it is supposed to be, then I should be
notified about it anyway outside of the backup process.
So if it is a cold backup, log in get your files shutdown etc startup. If it is a hot backup, then back it up. Why backup up a down database? First of all, it is down. Second, you should already have a backup [+ archives], whether 24 hours old or not... or however long up to the time it went down.
It is an art and a science. My logic begins assuming the database is up. Down databases don't need another backup, if it went down due to an issue, I would want manual control from then on.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zanen van, J (Jacob)
Sent: Monday, November 12, 2007 4:25 PM
To: oracle-l_at_freelists.org
Subject: Backup policy
Hi List,
When I started here a few months ago all scripts were sort of in place for backups but I have my doubts about something.
One of the things the scripts do is check if the database is up and running, and if not starts the database and mounts it to take the backup.
I seriously have my doubts about the validity of this, as this takes away the checking of why it was down in the first place.
My idea is to leave the check in but remove the portion of the script that start the database and just send an error if the database is down (maybe not even that as this is picked up by open view already)
What is your thought on this?
Brgds
Jack
This email, including any attachments, may be confidential or privileged, and is sent for the personal attention of the intended recipient. If you have received this email in error, please delete it immediately. The views expressed are not necessarily those of the Rabobank Group. The Group is not liable for the effects of any virus which may be contained in this email.
If this email contains marketing material and you do not wish to receive such material by email in future, please reply to this email and place the words "Remove My Details - Electronic Messages" in the Subject Header.
The Rabobank Group
Australia: 1800 025 484
New Zealand: 0800 500 933
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2007 - 07:04:09 CST
 |
 |