Re: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 23 Aug 2005 14:47:16 -0700
Message-ID: <bf463805082314477c752572@mail.gmail.com>

v$datafile
FILE_NAME

---

STATUS UNRECOVERABLE_TIME UNRECOVERABLE_CHANGE#

------- ------------------- ---------------------

/u01/oradata/dv03/test01.dbf
ONLINE 08/23/2005 12:33:51 1039632753

---

14:44:28 SQL>l
1* select * from v$backup_corruption
14:44:29 SQL>/ no rows selected

---

DBV: I have not included any dbv output. dbv reports every file I test as corrupt ( including SYSTEM) This is with the database shutdown.
Don't know what the problem there is, but I'm not going to pursue it right now.

Jared

On 8/23/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Thanks for the great test case Jared - just a few questions:
> Can you check the following to see if there is any indication of
> corruption due to the recovery through the nologging operation:
> - v$datafile: unrecoverable_time & unrecoverable_change# columns
> - v$backup_corruption
> - run dbverify on the datafile
> Have you submitted your case to Oracle support to see if it is a bug, or
> if we're all missing something?
> Thanks again,
> Brandon
>
> -----Original Message-----
> *From:* Jared Still [mailto:jkstill_at_gmail.com]
> *Sent:* Tuesday, August 23, 2005 12:46 PM
> *To:* Hemant K Chitale
> *Cc:* Allen, Brandon; cmarquez_at_collegeboard.org; oracle-l_at_freelists.org
> *Subject:* Re: ORA-1578...block corrupted...error is normal...a
> block...had a NOLOGGING...operation performed against
>
>
> On 8/23/05, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
> >
> >
> > Jared,
> >
> > You ARE right. You really don't need to retest it.
>
>
> Maybe not, but I want to.
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Tue Aug 23 2005 - 16:49:20 CDT