现网双中心物化视图刷新出现:
Errors in file /u01/app/admin/zxin/bdump/zxin1_j001_61864.trc:
ORA-12012: error on auto execute of job 25
ORA-12048: error encountered while refreshing materialized view "ZXDBM_830"."S830USERMARK1"
ORA-10632: Invalid rowid
ORA-02063: preceding line from ZXINCMP
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Wed Jan 16 05:23:28 CST 2013
Thread 1 advanced to log sequence 136 (LGWR switch)
查询关键错误:
oracle@pt1bakdb1:~> oerr ora 10632
10632, 00000, "Invalid rowid"
// *Cause: Segment Highwatermark was overwritten due to shrink and space reused
// *Action: Reissue this command.
oracle@pt1bakdb1:~> timed out waiting for input: auto-logout
很显然是在查询刷新原库的时候,原库的定时任务做了shrink Segment 操作,导致查询发起时刻的Segment(S830USERMARK1)高水线被覆盖、重写导致的
重新执行一下刷新就Ok了 。