Re: Recovery from noarchive db corrected
Sinardy, what's your uptime requirement? You're allowed a weekly cold shutdown for backup? what I'm asking is - when you are copying the datafiles to tape, its during a clean, cold shutdown, right? Have you ever tested the recovery portion of your backup/recovery scheme? If your 'copying files to tape' is from an open database, you'd be in for a real surprise when you attempt to restore the full set. You have no other recovery options than the full set - its zero datafiles or all of them. If you create your batch loads so as to minimize the amount of redo, archivelog might not seem like such a performance hit. Give the system a dedicated channel and pair of drives (each) for both online and archived redo logs, and don't worry about the performance hit. try it, you'll like it: SVRMGR startup mount pfile=pfile_path SVRMGR alter database archivelog; SVRMGR archive log start SVRMGR alter database open; SVRMGR alter database backup controlfile to trace; SVRMGR archive log list Paul Sinardy Xing wrote: Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: ? ? Our Developer prefer the archive off, I can't change that anymore :( ? ? -Original Message- ? Sent: Thursday, 5 April 2001 8:54 PM ? To: LazyDBA mailing list ? ? Turn archiving on. ? ? ? -Original Message- ? ? From: Sinardy Xing [mailto:[EMAIL PROTECTED]] ? ? Sent: Thursday, April 05, 2001 4:57 AM ? ? To: LazyDBA mailing list ? ? Subject: Recovery from noarchive db corrected ? ? ? ? ? ? Hi, ? ? ? ? My database is noarchive mode, what should I do to prevent ? ? from lossing any ? ? transactions ? ? ? Like for example incresed the REDO buffer to ... (daily buffer)? ? ? Will this decrese the performance ? ? ? any technique to share ? ? ? ? ? Sinardy ? ? ? ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Recovery from noarchive db corrected
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. With no disrespect to your English, the phrase "weakly copy of dbf files" (rather than weekly) seems rather appropriate. As several other listers have stated, by far the best option is to enable archive logging. Whilst you seem to have the bases covered, have you considered how long it will take to re-apply the batch files and whilst there may not be much online input you are running the risk of losing all data that has been input after your last export and before the next one. Best advice seems to be try archive logging and identify the impact then make a considered judgement. John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 11:10 To: Multiple recipients of list ORACLE-L Subject: RE: Recovery from noarchive db corrected Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbar
RE: Recovery from noarchive db corrected
The normal method is to copy out the days worth of archive log file as part of your normal backup routine. Then maybe keep 2 days worth on-line so that they are available for a recovery without getting them back from tape. Keep a watch on the disk space to ensure that the disk does not get full and a new archived redo log cannot be created. John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 12:56 To: Multiple recipients of list ORACLE-L Subject:RE: Recovery from noarchive db corrected Hi Hallas and All DBAs Thank you for your advise. I have a question if I turn on our archive redo log do I need to copy out that archive log frequently ? -Original Message- John Sent: Friday, 6 April 2001 7:21 PM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. With no disrespect to your English, the phrase "weakly copy of dbf files" (rather than weekly) seems rather appropriate. As several other listers have stated, by far the best option is to enable archive logging. Whilst you seem to have the bases covered, have you considered how long it will take to re-apply the batch files and whilst there may not be much online input you are running the risk of losing all data that has been input after your last export and before the next one. Best advice seems to be try archive logging and identify the impact then make a considered judgement. John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 11:10 To: Multiple recipients of list ORACLE-L Subject: RE: Recovery from noarchive db corrected Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer
RE: Recovery from noarchive db corrected
Hi Hallas and All DBAs Thank you for your advise. I have a question if I turn on our archive redo log do I need to copy out that archive log frequently ? -Original Message- John Sent: Friday, 6 April 2001 7:21 PM To: Multiple recipients of list ORACLE-L FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. With no disrespect to your English, the phrase "weakly copy of dbf files" (rather than weekly) seems rather appropriate. As several other listers have stated, by far the best option is to enable archive logging. Whilst you seem to have the bases covered, have you considered how long it will take to re-apply the batch files and whilst there may not be much online input you are running the risk of losing all data that has been input after your last export and before the next one. Best advice seems to be try archive logging and identify the impact then make a considered judgement. John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 11:10 To: Multiple recipients of list ORACLE-L Subject: RE: Recovery from noarchive db corrected Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ? Do you have any recomendation for better backup strategy ? -Original Message- Pather Sent: Friday, 6 April 2001 1:30 PM To: Multiple recipients of list ORACLE-L Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the abov
RE: Recovery from noarchive db corrected
I would tell them that THEY are then responsible for database recovery if a problem should occur. If the DBA is to be responsible, then the DBA should be able to utilize the recovery tools provided by the vendor (Oracle). [EMAIL PROTECTED] 04/06/01 12:45AM The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
Sinardy Xing wrote: The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? Sinardy, You definitely want to turn archiving on. Without it, your recovery options are limited to the last offline backup of the database. If you do an offline backup of the development DB every night, then the most that would be lost is one day's worth of development. Depending on how and where the developers write and store their code, the least that would be lost is one day's worth of transactions in the development DB. Beyond that however, is the fact that you are a developer in a sense as well. Tuning databases to avoid the kind of contention the developers are worried about is part of what you do for a living. If the developer's fears are correct, and archiving causes their database to respond poorly, what will happen when their code goes into an archived production database? There are many parameters you can alter and steps you can take to reduce, minimize, or eliminate this type of contention. Combinations of things like adding redo logs, increasing the size of the log buffer, altering checkpoints, looking at v$latch and making appropriate adjustments to log_small_entry_max_size or log_simultaneous_copies are just a few of the options available to you as the DBA. Examining the code processing the batch is another. Tuning is like detective work, and is probably my favorite part of being a DBA. Start with one of the tuning manuals off OTN, then pick up (and read) Steve Adam's "Oracle 8i Internal Services" from O'Reilly. You'll be a better DBA, and who knows, you might even be able to teach the developers a trick or two. Good Luck. David A. Barbour Oracle DBA -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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 --
Re: Recovery from noarchive db corrected
Here, here!!! If they can dictate the fact the the DB will not be in archive log mode, they must live with unrecoverability. Terry Tim Sawmiller wrote: I would tell them that THEY are then responsible for database recovery if a problem should occur. If the DBA is to be responsible, then the DBA should be able to utilize the recovery tools provided by the vendor (Oracle). [EMAIL PROTECTED] 04/06/01 12:45AM The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [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
RE: Recovery from noarchive db corrected
Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
Sinardy, Who will recover the database in case of a failure? Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead on performance of your database. You cannot sacrifice backups for a marginal increase in performance especially if your db is a high transaction processing system. Regards Suhen The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] 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: [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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: Suhen Pather INET: [EMAIL PROTECTED] 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: [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: Recovery from noarchive db corrected
The actual archiving of log files itself should not impact the performance of the insert jobs, unless the archiving process is slow enough to cause the database to pause while a log is archived so it can be reused. The only other reason why the developers wouldn't want it is if the space required to store the archived logs impinges on their development space; in that case, you'd have a case for getting more storage. Either way, the inability to recover a database due to the absence of logs is far worse! -a [EMAIL PROTECTED] 6/4/2001 14:45:28 This message has been scanned by MAILSweeper.The developer application running huge batch inserting data into database,that is what they told me, if you are me what you will do?-Original Message-TestaSent: Friday, 6 April 2001 11:55 AMTo: Multiple recipients of list ORACLE-Lassuming you're the dba, since when does the developer dictaterecoverability to a DBA about a database.sounds like a role problem there.joeSinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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).--Joe Testa http://www.oracle-dba.comPerforming Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com domain, its not going cheap but feel free toask :)--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Joseph S. Testa INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sinardy Xing INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **