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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
