Robert, What if the RMAN incremental facility is used and the blocks get corrupted in an unchanged space? Will RMAN then identify the corruption?
Arup ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 10:39 AM > No need to do any of this if you are using RMAN. With each backup, RMAN > checks each block backed up for any corruption. Corruption will be reported > and you > can opt to allow a certain amount of it or none. > > Rf > > Robert G. Freeman > Technical Management Consultant > TUSC - The Oracle Experts www.tusc.com > 904.708.5076 Cell (it's everywhere that I am!) > Author of several books you can find on Amazon.com! > > > > -----Original Message----- > Sent: Friday, January 17, 2003 8:19 AM > To: Multiple recipients of list ORACLE-L > > > I would do all three. A good backup stategy is only good if you read all > your data all the time. You can have corrupt data that doesn't get read and > doesn't cause a problem for weeks, month, years. By that time you have no > backup that does not contain corrupt data. Export to a null file to speed > things up a little, just keep the log file. DBVerify is very useful. > > R.Smith > > -----Original Message----- > Sent: Friday, January 17, 2003 7:59 AM > To: Multiple recipients of list ORACLE-L > > > >I am considering the appropriate way to do database > >corruption prevention. > > > >Should I use one or more of the following as a > >proactive measure ? > > a) Export > > b) DBVerify > > c) Analyze table <table_name> validate structure > >cascade > > > >Any advice ? > > > >Thanks, > > > >PH > > > > Pui Ho, > > The only way you can be 'proactive' concerning corruption is to have a > sound backup strategy - if you really feel nervous about your hardware, > first change it, and then use archive logging and the rest; export is a bad > solution, because it will be long to restore. By definition, a corruption > doesn't give any warning (it's even worth than earthquakes). If you want to > be very reactive, set something to regularly scan your alert.log file. > > Regards, > > Stephane Faroult > Oriole > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Faroul > 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). > If you are not the intended recipient of this e-mail message, any use, > distribution or copying of the message is prohibited. Please let me know > immediately by return e-mail if you have received this message by mistake, > then delete the e-mail message. Thank you. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Smith, Ron L. > 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.net > -- > Author: Freeman Robert - IL > 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.net -- Author: Arup Nanda 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).
