Moving datafiles - Thanx

I'll keep this in mind !

Thanx all for the information, I knew I missed some things. :-)

Greets,

Kirsten

> -----Original Message-----
> From: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
> Sent: Thursday, July 06, 2000 3:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:RE: Moving datafiles
>
> 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____________________
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author:
> INET: dgoulet_at_vicr.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
Received on Thu Jul 06 2000 - 10:17:23 CDT