Re: RBS and refreshing snapshots
Date: 1996/05/31
Message-ID: <4oni5d$ed_at_nntpa.cb.att.com>#1/1
chuckh_at_dvol.com (Chuck Hamilton) wrote:
>Can someone explain why I got an error saying that rbs 'R02' couldn't
>be extended while refreshing a snapshot where I specifically asked for
>rbs 'RLRG'? I've verified that RLRG is ONLINE and nobody else is using
>it.
>
>Message follows:
>
>begin dbms_snapshot.refresh('CODE','?','rlrg'); end;
>
>*
>ERROR at line 1:
>ORA-12008: error in snapshot refresh path
>ORA-01562: failed to extend rollback segment (id = 3)
>ORA-01628: max # extents (20) reached for rollback segment R02
>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 248
>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 131
>ORA-06512: at line 1
>
>--
>Chuck Hamilton
>chuckh_at_dvol.com
Let me guess, you must be doing a complete refresh. In Oracle 7.2.2.3 you cannot attach to a specific rollback segment when doing a complete refresh. This is a known bug. I heard this has been fixed in 7.2.3.
If you are doing a fast refresh, attaching to the specified rollback segment works.
Naren Chintala
AT&T
naren_at_mink.att.com
Received on Fri May 31 1996 - 00:00:00 CEST