Re: Database Verification

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" <ORACLE-L_at_fatcity.com> 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: sfaroult_at_oriolecorp.com
>
> 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: 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).
> 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: rlsmith_at_kmg.com
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
> INET: FREEMANR_at_tusc.com
>
> 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: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

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: 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).