Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: move datefiles (almost) online
Hi!
And since you put your TS read only and took it offline a checkpoint was performed and it's contents freezed, thus you didn't even have to apply the recover command...
Tanel.
"Hermann Schlösser" <hschloes_at_gmx.de> wrote in message
news:3E6536B1.50300_at_gmx.de...
>
>
> Ralph Ganszky wrote:
> > Hi Hermann,
> >
> > I would prefer to set only the file which is moved offline, because if
you
> > have
> > a tablespace with more than one file, you will get less errors.
>
> tnx for the hint. Indeed tablespace contained one file only.
>
> Last night I used this procedure and it worked great.
> Maximum offline time with an 8 GB datafile was 7 seconds.
> Others were smaller and MUCH faster.
>
> Applicationservers did not bobo.
>
> (of course I put some checks into the beginning of the script:
> is destination writable, was file really copied, and - at first - does
> sourcefile exist)
>
>
> have fun
> Hermann
>
Received on Wed Mar 05 2003 - 18:12:09 CST