Re: Rebuilding indexes

Jeremiah Wilton wrote:

>
> Vadim Gorbounov mentioned the column 'unrecoverable_change#' in v$datafile.
> This looks like an SCN, not a count of unrecoverable changes. Either way, it
> seems like a useful way to decide if a datafile shoule be refreshed onto the
> standby. I can even imagine improving a standby log applier that could be made
> to refresh such files from the primary automatically.

I'm not sure this is an accurate indicator. There is also a column 'unrecoverable_time' in v$datafile. I checked a database that we have a standby for. It had files that had a non-zero value for unrecoverable_change# and the unrecoverable_time (in both production and standby) was several months ago. The database has been bounced several times between the unrecoverable_time and today. The db has been tested for recoverability (since we just recently made a standby of it); and the standby opens OK and the tablespaces are accessable.

I thought at first that it was because these were locally managed tablespaces, but at least one is dictionary managed. What else should/could I look for? Since this is a new process for us, it would be nice to have something to know to look for to trigger a refresh of the standby or files on the standby.

>
> On another topic, I believe I qualify for some sort of award as uber geek.
> This week I obtained the Washington State license plate "ORA DBA" for my '74
> Volvo.
>
> It got me thinking that it would be fun to have some bumper stickers made up for
> members of this list. Some ideas I had:
>
> "ARE YOU AN IDIOT?"
>
> or
>
> "SHUTDOWN ABORT"
>

Or "HELP I'M AN IDIOT.

>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton

Terry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  INET: terry_ball_at_csgsystems.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).