Re: SNAPSHOT REFRESH

From: Faan DeSwardt <faan_at_sbcglobal.net>
Date: Mon, 9 Aug 2004 09:21:56 -0700
Message-ID: <000401c47e32$4f942530$cf63400a@verifone.com>

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_at_hotmail.com> To: <oracle-l_at_freelists.org> 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_at_radisys.com
> >Reply-To: oracle-l_at_freelists.org
> >To: oracle-l_at_freelists.org
> >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_at_freelists.org
> >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_at_freelists.org
> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Aug 09 2004 - 11:53:46 CDT