Re: snapshot a step beyond

I agree with ajgonzal. Check your database parameters in your init.ora or v$parameter table -
'job_queue_processes' and job_queue_interval - it should be at least as much is your refresh interval of the snapshot. Also you will need to check in DBA_SNAPSHOTS column REFRESH_GROUP with jour DBA_JOBS id (JOB) and check it if it is BROKEN or if number of FAILURES is more than 0. Also check jour SNAPSHOT_LOGS if there is any data. Each time the snapshot is refreshed, the logs of the refreshed records are removed.

Try using 'dbms_snapshot.refresh('<snapshot_name>,<method>)' in SQL*Plus and see the result and messages you are getting.

Can I ask you how big is the table that you want to replicate and how often you plan to refresh it? We had some horror stories with fast snapshots of (very volatile) tables bigger than 500000 rows.

Hope this helps

Fabijanic Kresimir

root wrote:

> hi !
>
> now my link is working,
>
> and i can test my snapshot but !!!!
>
> on my master table i make a snapshot log on my table
> whend i put somme values inside i can see change in the log table !!good,
>
> on the 'slave' base i call the snapshot commande like
>
> create snapshot mysnap select * from table_at_WEB;
>
> after that i have a table mysnap with all the value off the table table on
> the master side WEB,
>
> but the slave table table is always empty !!!!
>
> i don't understand very well !!!
>
> for me i have created the slave db like the master with the same script ,
> and i have exactly the same table name on each side ....
>
> help me please !!!!
>
> thank you
> --
>
> --------- gorain pascal --------------
> --------- pgorain_at_teaser.fr -------------

Received on Sun Mar 28 1999 - 06:41:59 CST