Re: Moving Datafiles

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).
Received on Fri Jun 16 2000 - 02:29:41 CDT