RACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:RE: DBMS_REPAIR Package
>
>
> I dug a little more and found my answer. I found that Oracle uses
> DBMS_REPAIR just to put a band-ai
There's a good argument for separating tables/indexes.
[EMAIL PROTECTED] wrote:
>
> If you ran dbverify with the database up, it's very likely that
> there is nothing wrong with the datafiles.
>
> If dbv reads a block in transition, it will appear corrupt.
>
> Run it again, and there will eithe
ECTED]
07/17/2003 07:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: DBMS_REPAIR Package
I dug a little more and found my answer. I found that Oracle uses
DBMS_REPAIR just to put a band-ai
Title: Message
Hi Stefick,
Running stored procedures/packages is somewhat
difficult with a shutdown database, so the database needs to be
opened.
Depending on the type of corrupted block in
question answers whether or not the block is actually repaired (eg. bitmap block
in ASSM segments,
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: DBMS_REPAIR Package
>
> I dug a little more and found my answer. I found that Oracle uses
> DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically
> identifies the corrupt block and marks it so oracle s
Title: Message
I dug a little more and found my
answer. I found that
Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It
basically identifies the corrupt block and marks it so oracle skips over it like
it's not even there.
-Original Message-From: Stef
s in the World Wide
> Support does suggest that the influxed blocks are very likely to be a
> fractured block. But I reallly have no idea how it got in there... .
>
> Winnie
>
>
>
>
>
> yong huang <[EMAIL PROTECTED]> on 03/23/2001 04:01:21 PM
>
> To: [EMAIL PR
Hi, Murali,
You don't subscribe to a newsgroup such as comp.databases.oracle.server as you
do to a mailing list. If your company has a news (NNTP) server, configure your
browser to user it and type the URL news:comp.databases.oracle.server to
read/post messages. Most companies use "news" or "snew
s are very likely to be a
> fractured block. But I reallly have no idea how it got in there... .
>
> Winnie
>
>
>
>
>
> yong huang <[EMAIL PROTECTED]> on 03/23/2001 04:01:21 PM
>
> To: [EMAIL PROTECTED]
> cc: [EMAIL PROTECTED], [EMAIL PROTECTE
1 04:01:21 PM
>
> To: [EMAIL PROTECTED]
> cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
>
> Subject: Re: DBMS_REPAIR package usage
>
>
> Hi, Winnie,
>
> Just a little more research. I wonder how you can have an rdba that big,
> 0x24070020,
Yong,
Thanks a lot for all the research! :D
The file# that actaully contains this block is 9. My database is not that
big at all.
I did do some research myself and some Oracle analysts in the World Wide
Support does suggest that the influxed blocks are very likely to be a
fractured block. But
Hi, Winnie,
Just a little more research. I wonder how you can have an rdba that big,
0x24070020, which is 604438560 in decimal.
SQL> var a number;
SQL> exec :a := dbms_utility.data_block_address_file(604438560);
PL/SQL procedure successfully completed.
SQL> print
A
-
144
hursday, March 22, 2001 5:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DBMS_REPAIR package usage
>
>
>
> I would not decide whether a block is corrupted or not, just using dbv
> utility. dbv reports corruption, even when analyze, exp and FTS goes
> through fin
; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 5:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DBMS_REPAIR package usage
>
>
>
> I would not decide whether a block is corrupted or not, just using dbv
> utility. dbv
I would not decide whether a block is corrupted or not, just using dbv
utility. dbv reports corruption, even when analyze, exp and FTS goes
through fine without any problem. dbv reported a data dictionary corruption
in our case. We ran analyze, exp and FTS, no problem. But still dbv was
reporting
15 matches
Mail list logo
