Re: SNAPSHOT REFRESH

Seema,

I have seen this happen when you refresh instances and use DBMS_JOB to
refresh your materialized views (AKA snapshots).  What usually happens is
that just after you open the database (after creating the control file of
the new instance and perform any recovery if hot backup was used) the
DBMS_JOB runs and refreshes the MV's in the new instance and resets the MV
logs on the source (usually production!).

If this is your case then include an 'ALTER SYSTEM SET JOB_QUEUE_PROCESSES =
0;' in your rebuild script just before you issue the 'ALTER DATABASE OPEN
[RESETLOGS];' statement.  Once the DB is open then include a step to drop
the DBMS_JOB that refreshes the MV's and then issue an 'ALTER SYSTEM SET
JOB_QUEUE_PROCESSES = n;' where n is the value that you would like to run in
your non-production instances.

Good Luck!

-f

----- Original Message ----- 
From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, August 09, 2004 5:52 AM
Subject: Re: SNAPSHOT REFRESH


> Jared,
> I did the same and fixed .Wondering I have been getting same error
daily.Is
> there any way to fix this?
> thx
> -Seema
>
>
> >From: Jared.Still@xxxxxxxxxxx
> >Reply-To: oracle-l@xxxxxxxxxxxxx
> >To: oracle-l@xxxxxxxxxxxxx
> >Subject: Re: SNAPSHOT REFRESH
> >Date: Fri, 6 Aug 2004 14:06:14 -0700
> >
> > > Hi,
> > > I have been noticing following error during refreshment of snapshot.
> > > *
> > > ERROR at line 1:
> > > ORA-12034: snapshot log on "AWAY"."CATEGORY_TAB" younger than last
> >refresh
> > > ORA-06512: at "SYS.DBMS_SNAPSHOT", line 610
> > > ORA-06512: at "SYS.DBMS_SNAPSHOT", line 667
> > > ORA-06512: at "SYS.DBMS_SNAPSHOT", line 647
> > > ORA-06512: at line 1
> > > How to fix this ?
> > > thanks
> > > -Seema
> >
> >I've fixed this by recreating the refresh group.
> >
> >Jared
> >
> >
> >----------------------------------------------------------------
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >----------------------------------------------------------------
> >To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> >put 'unsubscribe' in the subject line.
> >--
> >Archives are at http://www.freelists.org/archives/oracle-l/
> >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> >-----------------------------------------------------------------
>
> _________________________________________________________________
> Check out Election 2004 for up-to-date election news, plus voter tools and
> more! http://special.msn.com/msn/election2004.armx
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: