NOLOGGING recovery errors
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 06 Dec 2010 11:03:44 -0500
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:
