Re: NOLOGGING recovery errors
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 06 Dec 2010 11:36:18 -0500
Actually when i try and ALTER INDEX REBUILD these indexes with the block
NOLOGGING it says it has block corruption, so that's probably with Oracle tells
you to drop then create.
-----Original Message-----
From: lyallbarbour@xxxxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: Mon, Dec 6, 2010 11:25 am
Subject: Re: NOLOGGING recovery errors
Cause Metalink Article #794505.1
says to rebuild indexes by drop/create them and i can't do that with primary
keys or unique indexes in general. I need to disable the constraint, then drop
then re-create with LOGGING turned on.
I'm just following that article since i have this NOLOGGING problem with
corrupt blocks after the recovery
Lyall
-----Original Message-----
From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante@xxxxxxxxxxxx>
To: lyallbarbour@xxxxxxxxxxxxxxx <lyallbarbour@xxxxxxxxxxxxxxx>
Sent: Mon, Dec 6, 2010 11:17 am
Subject: RE: NOLOGGING recovery errors
Lynn,
Why not just rebuild the invalid indexes?
Declare
Begin
For c1 in (select index_name from user_index
Where status=’INVALID’) loop
Execute immediate ‘alter index ‘ || c1.index_Name || ‘ rebuild’;
End loop;
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of lyallbarbour@xxxxxxxxxxxxxxx
Sent: Monday, December 06, 2010 11:04 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: NOLOGGING recovery errors
Hi,
I rebuilt some indexes on our production database yesterday with NOLOGGING.
They took a cold back up. But this morning when we refreshed our test
instance, they refreshed with the hot backup, so after applying the archive
logs, we are getting corrupt block errors. I'm trying to rebuild the indexes,
drop then create from the ddl, but i'm having a hard time with the script,
since we are on 10.2.0.4 How can i generate the ddl for
alter table disable constraint -- then
drop index
for all these primary keys? I'm sure this is on google somewhere, but i
haven't found it yet.
Thanks,
Lyall
=
Other related posts:
