Re: DB Corruption

From: Jamie Kinney <OracleDude_at_gmail.com>
Date: Thu, 30 Sep 2004 16:00:49 -0700
Message-ID: <d4841181040930160046983c9@mail.gmail.com>

David,

These views/tables each have CORRUPTION_CHANGE# in them. You could use the SCN_TO_TIMESTAMP function to get the time that the corruption was detected.

>From the docs, this column stores the "Change number at which the
logical corruption was detected. Set to 0 to indicate media corruption."

-Jamie

select scn_to_timestamp(1711819000) from dual;

SCN_TO_TIMESTAMP(1711819000)

---

30-SEP-04 03.57.42.000000000 PM On Thu, 30 Sep 2004 15:02:32 -0700 (PDT), David <thump_at_cosmiccooler.org> wrote:
> We just realized we have a corrupted db. An export revealed this. RMAN
> records corruption to v$backup_corruption in the db and
> rc_backup_corruption in the catalog.
>
> How can we tie that info to determine when the corruption occured so we
> can consider our options.
> --
> ..
> David
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 30 2004 - 17:56:23 CDT