RE: Changes to db after renaming mount points

Hi Maheswara,

Thanks for all your help. I know I missed writing all the steps for moving datafiles (I got a bit lazy).

Regards,

Sujatha

-----Original Message-----
Sent: Wednesday, 5 December 2001 6:21 AM To: Multiple recipients of list ORACLE-L

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.
3. 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';
4. After copying all the data files of this tablespace, bring up the tablespace on line -- alter tablespace your_tablespace online;
5. For moving the redo logs, shutdown the database and open the database in mount state.
6. 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: Maheswara.Rao_at_Sungardp3.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.cwo.net.au

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).