Sujatha,
You could do this in two ways --- either through recreating the control file
-- (alter database backup controlfile to trace) and then make modfifications
of new disk locations to the control file (trace file). Then from cold
backup, copy the databse files to those new locations and bring up the
datbase using the new modified controlfile.
Second method:
All of your steps are ok but you missed --- mounting the datbase before
moving redo and taking the tablespaces offline. See below one details.
If you are on 817 version, following are the steps to move the datafiles
from one location to another location (I do not know whether these steps
would work for versions prior to 817).
1. Take the tablespace offline -- alter tablespace your_tablespace offline
normal;
2. Now, through another window on Unix, copy the data files to the new
location using unix command --- mv.
4. After completing the data file copy, then issue the command
alter tablespace your_tablespace
rename datafile '/export/home0/oracle/rbdb1/users01.dbf',
to '/export/home5/rbdb1/users01.dbf';
5. After copying all the data files of this tablespace, bring up the
tablespace on line -- alter tablespace your_tablespace online;
6. For moving the redo logs, shutdown the database and open the database in
mount state.
7. Move the redo log files to new locations using the unix command -- mv.
7. Now, issue the following command (i.e., when the database is in mount
state).
ALTER DATABASE RENAME FILE
'/export/home3/ora_log1.rdo'
TO '/export/home4/ora_log1.rdo';
8. Now, open the database for normal use.
Prior to doing and also after completing the above operations, take the cold
backup.
Thanks,
Rao
-----Original Message-----
Sent: Monday, December 03, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
I now have extra disks so I am re-arranging our databases. We will also be
renaming the mount points (obviously the db's are on UNIX - HP-UX).
I just want to confirm the steps I would have to do for this:
1. Make a cold backup
2. Move Controlfiles:
(i) copy existing cf's to new location
(ii) edit the control_files parameter in init.ora to change the existing
cf name.
3. Rename/move redo logs:
(i) Copy existing redo logs to new location
(ii) Do a ALTER DATABASE RENAME FILE for each redo log moved
4. Rename/move datafiles:
(i) Copy existing df's to new location
(ii) Do a ALTER DATABASE RENAME FILE for each datafile moved.
Does this sound fine? ... Have I missed anything? ... or should I look out
for something special?
Thanks for your help
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
