Re: URGENT: Need to move TS from ufs to vxfs file system

Nice ...
So what does your DBA book say about moving datafiles from the system tablespace ? (which btw can't be taken offline when the database is open) 1. shutdown the db
2. startup mount (this does not open the datafiles, but opens init.ora (nomount) & controlfiles (mount)
3. move the file (s)
4. alter database rename file 'xxxxx' to 'yyyyy' ; (this updates the controlfile)
5. alter database open (open the datafiles) 6. Bada Bing

notice the keyword 'file' in the 'alter database rename' command - so you can use it for either datafiles or redolog files ...

So basically his procedure is correct (except for the 'alter files' command ...) ...

I can hardly believe that the book doesn't mention this as this is pretty basic stuff ...

Kind regards
Koert

"damorgan" <damorgan_at_exesolutions.com> wrote in message news:3CACC182.BC16EA61_at_exesolutions.com...
> According to the DBA handbook the steps are:
>
> 1. Do not shut down the database
> 2. Take the tablespace off-line
> 3. Move the datafile(s)
> 4. Use the ALTER TABLESPACE command to rename the file within the database
>
> 5. Bring the tablespace back on-line.
>
> This does not correspond with what you did.
>
> Reference: Oracle 8i DBA Handbook, Loney & Theriault, pg 138.
>
> Daniel Morgan
>
>
>
> Larry wrote:
>
> > I really need help! FAST!
> >
> > I have some large tablespaces I need to move from a ufs file system to
> > a new-and-improved veritas file system. We are out of space and I
> > have to get this done. I followed the instructions to do this task...
> >
> > shutdown
> > copy dbf files to new location (I didn't move the files...)
> > startup mount
> > alter files '/v01/...' to '/v05/..'
> > alter database open
> >
> > Problem is, when I run a query against a table that is in the
> > relocated TS, the query just hangs. If I shutdown and put everything
> > back the
> > way it was, the query works fine.
> >
> > I am running Oracle 8.1.7.
> >
> > Any thoughts?
>
Received on Thu Apr 04 2002 - 15:29:31 CST