Re: Another Database Down

Interesting stuff about 'fuzzy' SCN's and files.

A couple of notes on MetaLink with pertinent information: 22956.1
1015544.102

The second one has the added benefit of making clear why your database should be shut down cleanly before taking a cold backup.

Jared

On Friday 25 May 2001 07:46, Jim Hawkins wrote:
> Laura,
>
> I fight this nearly every damn day. We constantly refresh several SAP
> systems from production copies via EMC BCV's and TimeFinder. About half of
> the time, I get the same error, where recovery was successful, but open
> resetlogs would fail. It turns out, in my case, that no amount of recovery
> will every get this database open (even with resetlogs) with this backup
> set. Apparently there is an issue with a piece of the EMC software that
> causes problems when mirrors are split during a hot backup. To make a long
> story short, there is an event you can set in via a server manager session
> that will dump all datafile headers. What you look for is what Oracle
> calls a "fuzzy SCN". That is, an SCN hex value that evaluates to a non-
> sensical number. In English, the SCN for the header should have some hex
> value that corresponds to a number. If it is set to something like
> FFxFFFFFFFF, then you have a "fuzzy SCN" which means your backup is bad and
> will never work. I don't know if this is your exact problem or not, but
> since you're getting the same symptoms I was, I thought I would throw it
> out there. You can read more on MetaLink by searching for "fuzzy SCN". By
> the way, as soon as our RS/6000 SA upgraded our version of PowerPath, the
> bug went away, we have consistent mirror splits, and all is well on the SAP
> backup/restore front...
>
> Sorry if I threw you way off on a tangent on this one.
>
> Jim
>
> Jim Hawkins

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).