RE: Moving Datafiles

First , step 3 of should be 'COPY ...' not 'MOVE', or Oracle will not recognize the moved file.
Second, I disagree with Singh. I think 'rename' is the preferred method here obviously because
this can be done on the tablespace level ( system tablespace is an exception here) which means
other parts of the database can be up during the operation. Recreating control file is a potentially
dangerous thing to do and database downtime is mandatory in that case.

Dennis Meng
Database Administrator
Focal Communications
847-954-8328

                                                                                       
                    Singh                                                              
                    Gunmeet-G1498        To:     Multiple recipients of list ORACLE-L  
                    7                    <ORACLE-L_at_fatcity.com>                        
                    <G.Singh_at_moto        cc:                                           
                    rola.com>            Subject:     RE: Moving Datafiles             
                    Sent by:                                                           
                    root_at_fatcity.                                                      
                    com                                                                
                                                                                       
                                                                                       
                    06/16/00                                                           
                    08:39 AM                                                           
                    Please                                                             
                    respond to                                                         
                    ORACLE-L                                                           
                                                                                       
                                                                                       

An easier way is to bypass the alter database rename step alltogether. This can be done by backing up the control file to trace. Make sure you shutdown the database using shutdown normal ( May need to shutdown immediate, startup and then shutdown normal) edit the control file script and modify the paths to the datafiles ( You can
also rename the datafiles if needed )
----Database name/SID also be changed at this point. Startup nomount
create new control files using the script. alter database open ( need to give resetlogs if database name has been changed. )

-----Original Message-----
Sent: Friday, June 16, 2000 5:12 AM
To: Multiple recipients of list ORACLE-L

You all forgot one thing:

SVRMGR> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; gotta make a new backup controlfile after renaming your datafiles ... right?

• drakonian

Surendra Tirumala wrote:
>
> Steps to be followed to move datafiles:
> 1)shutdown the database(normal/immediate)
> 2)take a backup as precautionery method
> 3)move what all datafiles u want to move to the
> locations you want
> 4)start the database in mount stage
> 5)point the database to new locations of the
> datafiles.
> this can be done using the sql statement:
> "alter database rename datafile 'old_name' to
> 'new_name';" (ofcourse, through svrmgr)
> 6)open the database.
>
> Surendra Tirumala
> DBA,
> Satyam,India
>
> --- Calvin Lim <calvin-lim_at_mediaring.com> wrote:
> > Hi all,
> >
> > We've just added a few spindles to our DB and I need
> > to move
> > datafiles for some of my tablespaces across to the
> > newer spindles
> > in order to spread the io. What are the steps i've
> > got to take
> > to achieve the movement of the datafiles?
> >
> > Thanks again for all your help.
> >
> > Regards,
> > Calvin
> >
> > -----BEGIN PGP PUBLIC KEY BLOCK-----
> > Version: PGPfreeware 6.0.2i
> >
> >
> mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1
> >
> gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+
> >
> 6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1
> >
> uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768
> >
> cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4
> >
> gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl
> >
> ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR
> >
> t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg
> >
> pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1
> >
> SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF
> >
> kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS
> >
> f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2
> > tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw==
> > =FOMk
> > -----END PGP PUBLIC KEY BLOCK-----
> > --
> > Author: Calvin Lim
> > INET: calvin-lim_at_mediaring.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).
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Surendra Tirumala
> INET: stirumala72_at_yahoo.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).

--
----------------------
Paul Drake
paled_at_home.com
----------------------
--
Author: Paul Drake
  INET: paled_at_home.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: Singh Gunmeet-G14987
  INET: G.Singh_at_motorola.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