RE: Moving datafiles

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Thu, 12 Oct 2000 11:58:23 -0700
Message-Id: <10647.119098@fatcity.com>

Hi :dba

first backup your database:)

Move control files

1. shutdown normal 
2. move control file to new location using OS command
3. edit init.ora and edit the control_files parameter with new locations and

restart db .. thats it

Move data/log files files

1. alter dataabse backup controlfile to trace;
2. shutdown normal 
3. move all data/log files to new locations using OS command

at this point u have two choices to go ahead -->
	option 1.
		startup mount
		alter database rename 'oldfile1' to 'newfile1', 'oldfile12
to 'newfile2' ...... all ur files
		alter database open 
		done !!
	option 2.
		startup nomount
		edit the control file trace u created in step 1 and edit new
file locations
		create the new controlfile by executing the above script
(trace file)
		alter database open 
		done !!

u r all set .. the latter is easier i would think ..

hth
deepAk

PS: :dba --> dba_at_bind :)

-----Original Message-----
From: dba_at_bind.com [mailto:dba_at_bind.com] Sent: Thursday, October 12, 2000 11:41 AM To: oracledba_at_quickdoc.co.uk
Subject: Moving datafiles

What's the best/least painful way to move controlfiles, datafiles, ect. database files between disk drives on 7.3.4/NT 4. The disk they currently live
on is full and need to get them off and onto a new drive.

Any suggestions?

TIA

---

Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Received on Thu Oct 12 2000 - 13:58:23 CDT