Re: Backup Strategy - Informal Survey
I do nightly exports of my large databases with ROWS=N. This way I can restore users, grants, indexes, table definitions, etc. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 09/20/02 10:13AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Backup Strategy - Informal Survey
Our db size is around 350Gig. We have stopped full logical exports since our database size has grown above 200 Gigs. It is just not feasible for us to do the full exports anymore, time it takes to export is too much. We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. So we do not feel logical exports an important part of our backup/recovery strategy. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 10:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Backup Strategy - Informal Survey
An export with data will probably cause more headaches than it solves in large DBs. A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks. Mike Jenner Database Administrator -Original Message- Sent: 20 September 2002 15:53 To: Multiple recipients of list ORACLE-L Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Backup Strategy - Informal Survey
Robert I don't think a full export has a place since your largest tables are probably too large to reimport in a reasonable amount of time. I like Jay's suggestion though. But your original question wasn't about a full export, you just said export. My answer is a definite yes. Following Pareto's rule (80/20), of the hundreds of tables, most will be relatively small, where import would be feasible. I find that developers often need to tinker with small codes tables, for example. Since they don't want to write a screen for an infrequent task, there is a higher-than-average chance they will bollix the table. Being able to quickly produce a week-old copy of the table can be a real butt-saver. And a heck of a lot easier to do from an export than a TSPITR. I also try to impress on the developers that before they monkey with a table to ask me to do a special export, and that gives me the chance to innocently ask what they are up to. Previously I did exports of large tables because that checked each block, but with RMAN, that is not necessary. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 20, 2002 9:13 AM To: Multiple recipients of list ORACLE-L I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Backup Strategy - Informal Survey
On Fri, 20 Sep 2002, Nat wrote: We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Backup Strategy - Informal Survey
No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM. So we thought lets go for a cold backup on weekends. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 12:28 PM On Fri, 20 Sep 2002, Nat wrote: We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Backup Strategy - Informal Survey
Well I just happen to know of this great Oracle Press RMAN book due out in October! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, September 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i. I need incremental backups fast :) Gene [EMAIL PROTECTED] 09/20/02 10:53AM Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Backup Strategy - Informal Survey
On our larger database we do exports of some of the smaller users which also have frequent changes. I wish I had some of the larger tables also, it would have saved a big headache last week getting one table restored (7 days to get the files restored from tape, 1.5 hours to modify the control trace file, do a partial recovery, export the table, and import it). Jay Miller -Original Message- Sent: Friday, September 20, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Well I just happen to know of this great Oracle Press RMAN book due out in October! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, September 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Robert - My info: Oracle 8.1.7 E.E. Largest DB is 900gb Hot Backups 2x week Cold Backups 1x month Export Backups 1x week on selective schemas I do export backups for creation of test db's, recover data validation blunders, i.e. single object restores. Future plans are RMAN, RMAN, RMAN on 9i. I need incremental backups fast :) Gene [EMAIL PROTECTED] 09/20/02 10:53AM Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Backup Strategy - Informal Survey
Nat Just a plug for always testing your backups, regardless of whether you are doing hot or cold. We do cold backups, and we test them from time to time by restoring them on a test system so the developers have some data to test against. Several times over the years we've found that a file was being skipped on the backup due to an oversight on the people side, or some other issue that developed over time and impacted the backup process. Right now I am both using RMAN and cold backups simply because I haven't had time to complete the qualification process to finally say absolutely that our RMAN backups will recover us from any situation. Just that this has been a lower priority than all the other tasks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 20, 2002 12:52 PM To: Multiple recipients of list ORACLE-L No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM. So we thought lets go for a cold backup on weekends. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 20, 2002 12:28 PM On Fri, 20 Sep 2002, Nat wrote: We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our database once a week for half an hour for cold bcv splits. So far it has worked very well. Just curious, why do you do a cold backup weekly? Do you not trust your hot backups? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).