Re: Question: ONE corrupted tablespace in standby db???

From: joel garry <joel-garry_at_home.com>
Date: 19 Jun 2006 11:31:45 -0700
Message-ID: <1150741905.033674.235760@i40g2000cwc.googlegroups.com>

BD wrote:
> > The index rebuild is fully self-inflicted. Doh!
>
> Zip it.

He's right. You need to know all the implications of nologging operations, they will bite with a standby. You may have to rebuild the standby any time you do anything that invalidates your backups. Perhaps you can get away with it this time by rebuilding indices properly in the primary.

This is the kind of thing that allows things to be better when you upgrade, but the additional features in the upgrade give more to trip over. Dataguard and RMAN eventually become the way to go.

--
@home.com is bogus.
Take off your pants!  http://news.bbc.co.uk/2/hi/europe/5091154.stm

Received on Mon Jun 19 2006 - 13:31:45 CDT