Re: Oracle 8.0.6 - How to reset (zero) SCN ?

Even export/import will not zero out the SCN. The only way I know how to reset the SCN is to recreate the database.

It is also highly unlikely that resetting the SCN will help in your situation. When RMAN does recovery, it uses the SCN kind of like a timestamp to know how to reapply transactions. If the SCN is lower than what was saved in the datafiles, then while you may be able to restore the datafile, you won't be able to apply recovery.

HTH,
Brian

x54 wrote:
>
> Hi,
>
> I'm newbie in Oracle, so please forgive if my question is a stupid kind...
>
> I have Oracle 8.0.6 and due to bug 1083739 (and high SCN value)
> I'm not able to restore db with RMAN. One of the workarounds is
> to reset (zero) SCN.
>
> My question: Is it possible to zero SCN without export/import db ?
> Has someone tried this and know how to do that ? Are there any
> tools available ?
>
> Could you help ?
>
> TIA,
> /pds

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"