Re: moving the rbs tablespace

In article <81e0oh$o2k$1_at_nnrp1.deja.com>,   loumaus_at_my-deja.com wrote:
> is there a short description on howto move the whole rbs-tablespace on
> a working server....
>
> i tried to do so but when reactivating the rollbacksegemnt ( putting
it
> online ) the server echos "error changing datafile status ora-01113
> file 2 needs media recorvery"...
>
> of course the rbs-segemnts were set offline to move the tablespace
>
> i would appreciate any help
>
> thanks
>

See the DBA Manual:
1) Alter tablespace offline - in case of an rbs tablespace you would need to alter all the rbs segments in the tablespace offline and wait for the status to change since the segment is not offline just because the command to offline the segment completes. 2) Use an appropriate OS utility to copy the file(s) to their new locations
3) Use the alter tablespace rename command to change the control file entries to match the new file names
4) Alter the tablespace on-line and for rbs bring the segments on-line

Note - you will need other rbs segments available to supports users if you do this in with the DB in unrestricted mode.

Alternately you could allocate a new rbs tablespace and create segments in it then take your old ones off-line and drop the original tablespace. If the segments are private you would acourse need to update the init.ora to match or offline, drop, re-create segments in new tablespace to keep the same names.

I hope this helps. Make sure your v$rollstat status is offline and not offline pending when you try to do this.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 07:51:49 CST