| 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: Backups
Charlie,
I use Rman for all my backups. I like to have my database's up and available to the users all the time.
Rman makes backup and recovery a simple process. For my production db's, I will perform nightly Rman backups of the database and archivelog files, and weekly Rman Validates for both types of backup.
For development, I perform twice-weekly database backups, with interspersed archivelog backups with, again, weekly Rman Validates for both types of backups.
Hope this helps
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, April 01, 2002 9:38 AM
To: Multiple recipients of list ORACLE-L
Charlie - Currently on most of our systems we do a weekly cold backup and rely on archive logs for the rest of the week. We augment this with full exports a couple of days/week. This is not ideal. Previously we did nightly cold backups, but our systems grew to the point that wasn't practical. We tried hot backups a couple of years ago, but the time between issuing the start backup command and the system responding took too long on each tablespace, so we had to give that up. If I tried that today, I would ask this list for suggestions and might resolve the problem.
Now we are looking at moving to RMAN. Depending on the size of your
system, you should consider RMAN. It seems to offer many advantages,
especially the ability to perform on-line backups with no penalties. We are
starting by backing up to disk because that appears to be a little simpler.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, April 01, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L
Charlie,
We do a cold backup of the production database active tablespaces (36
GIG) each night and a cold backup each Sunday night of the full
database(active and read-only tablespaces 70 GIG). The reason we backup
the read-only each week is it is easier to restore from one tape and I
do not control the backup script. I find it easier to have the group in
control of the backups to just backup the whole server once a week. Then
I do not have to double check them all the time if I make changes to the
database read-only data. Every 6 months I move a lot of data from the
active tables to the archive tables and the majority of the time it will
take 2 - 3 weeks to gat all the data moved( I have space limits on my
archivelog destination). It can be a challange to make sure another
department updates and completes their work. Our system is primarly a
load in the am and query all day but there is a second instance that
contains all of the applications that are query and update
applications.
ROR mª¿ªm
>>> charliem_at_mwh.com 03/29/02 04:33PM >>> How many sites are doing cold backups? At what frequency?
How many sites are doing hot backups? At what frequency?
Does anybody know the existance of any "Best Practices" paper on the web that discuss the topic of Oracle backups? If so, what's the URL?
TIA!
--
Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131Lead, follow, or at least have the courtesy to get out of my way!
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 01 2002 - 09:28:28 CST
 |
 |