Re: Oracle8.1.7 snapshot refresh failed without any error message

jshen.cad_at_gmail.com wrote:
> hi,
>
> we use snapshot in oralce8.1.7 (HP-UX 11i). There are three
> snapshots which map main DB data to three satalite servers. On each
> satalite server there are three jobs configured to refresh snapshot
> tables every 5 min. One table( named service_t) which is included in
> snapshot contains 5.5million records.
>
> There had been refresh failures before. At those failure time, I
> cound determine refresh failure by " select job, failures, last_sec,
> next_sec from user_jobs".
>
> But, today application running on snapshot failed because data
> in snapshots does not sync. with main DB. there is NO failure record
> in user_jobs table, there is no error record in alert.log either. we
> tried with manual refresh , the operation finish successfully within
> one minute. But, new record in service_t did not synced to snapshot
> at all.
>
> As last resort, we delete and recreate MLOG table on service_t.
>
> How could I determine the error reason ?
>
>
>
>
> Joe

Anything in the alert log?

I'd suggest also looking into the possibility of upgrading to a version of Oracle supported during the current millennium. That dinosaur you are feeding is hopelessly obsolete.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org