Re:RE: Moving datafiles

From: <dgoulet_at_vicr.com>
Date: Thu, 6 Jul 2000 09:05:59 -0400
Message-Id: <10550.111331@fatcity.com>

Call me paranoid if you like, but my desired course of action on this has always been:

1. shutdown the database (either normal or immediate, but NOT abort)
2. cp /old_dir/old_file_name to /new_dir/new_file_name
3. startup mount the database
4. alter system rename file '/old_dir/old_file_name' to '/new_dir/new_file_name';
5. alter database open If the db opens at this point matters should be well.
6. check date/time stamps on both the old file and the new file. The new file date/time stamp should be just a minute or so ago while the old file date/time stamp should be earlier. If so, delete the old file.

Why one would ask?? I've trashed a couple of db's by not following these rules in the past. If you try to do this by offlining the tablespace you can run into the "datafile needs recovery" message. Also a mv is a one way thing. If you happen to mv from a good disk drive to a bad one there is NO fall back. (Been there, done that, and it still smarts!!!)

Dick Goulet

____________________Reply Separator____________________

Subject: RE: Moving datafiles
Author: Trassens Christian <trassenc_at_TELEFONICA.COM.AR> Date: 7/6/00 5:27 AM

Yes. However or the database is down or you put the tablespace offline first.

Regards.

> -----Mensaje original-----
> De: Solis Llera, Eduardo [SMTP:esolis_at_mapfre.com]
> Enviado el: Jueves 6 de Julio de 2000 07:54
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Moving datafiles
>
> yes that is correct.
>
> > -----Mensaje original-----
> > De: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_oranjewoud.nl]
> > Enviado el: jueves 6 de julio de 2000 11:44
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Moving datafiles
> >
> > Hi all,
> >
> > The simplest things sometimes keep confusing me, so I'll just ask
> > and see if someone agress or not :-)
> >
> > I need to move some datafiles around on Hp-UX 10.20
> >
> > I figure I can do this in two steps :
> >
> > 1. on the OS : mv original_dir\datafile.dbf new_dir\datafile.dbf
> >
> > 2. in the DB : alter database rename file original_dir\datafile.dbf to
> > new_dir\datafile.dbf
> >
> > Correct ???
> >
> > Greets,
> >
> > Kirsten
> > Living near Antwerp, Belgium
> > Working near Breda, Netherlands
> >
> > --
> > Author: Weerd de E.C. Kirsten
> > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Author: Solis Llera, Eduardo
> INET: esolis_at_mapfre.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Trassens Christian
  INET: trassenc_at_TELEFONICA.COM.AR

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Thu Jul 06 2000 - 08:05:59 CDT