Oracle-L: RE: corrupted block

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Wed, 26 Feb 2003 12:34:01 -0800
Message-ID: <F001.0055A7C3.20030226123401@fatcity.com>

What do you mean by the "Rman log" rachel? Are you talking about the v$backup_corruption view?

>From the Oracle RMAN Reference:

If the server session encounters a datafile block during a backup that has already been identified as corrupt by the database, then the server session copies the corrupt block into the backup and Oracle logs the corruption in the control file as either a logical or media corruption. RMAN copies the block in case the user wants to try to salvage the contents of the block.

If RMAN encounters a datafile block with a corrupt header that has not already been identified as corrupt by the database, then it writes the block to the backup with a reformatted header indicating that the block has media corruption.

and then, an interesting note:

RMAN cannot detect all types of block corruption.

Of course, if MAXCORRUPT isn't set, the one corruption should kill off the entire backup as long as that corruption is detected.

Was it the origional backup that was corrupted or was it data after it got to the tape (because of media corruption/failure)?

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 2/26/2003 12:21 PM

here's the fun part in this:

this is being handled by the hosting company who manages our production data center.

apparently rman detects corruption on the restore and writes error messages to the alert log, not the rman log. Except the monitoring software didn't look for the word "corrupt"

Stephen Lee <Stephen.Lee_at_DTAG.Com> wrote:
>
>
> > -----Original Message-----
> >
> > I'm dealying with the same RMAN not checking corruption -- on
> 9.2.0.1
> > and Solaris. and it's a data warehouse.
> >
>
> I've seen it detect corruption, and not detect it. I think it
> detects some
> kinds, but not all kinds. It seems to do better with finding it in
> archived
> log files than in data files. But that observation is based on a
> tiny
> sample of empirical data, so it shouldn't be taken as fact.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: Stephen.Lee_at_DTAG.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).
>

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).

Received on Wed Feb 26 2003 - 14:34:01 CST