Re:moving data files on Unix

From: <dgoulet_at_vicr.com>
Date: Thu, 31 Aug 2000 11:44:01 -0400
Message-Id: <10605.115991@fatcity.com>

Steff,

    My method:

1. alter database backup controlfile to trace;
2. shutdown (normal or immediate)
3. copy (not move) datafile(s) from old location to new (If you have a problem with the new file location you can always send the DB back to the old location until the new mount gets fixed.)
4. startup mount
5. alter database rename datafile <oldname> to <newname>;
6. repeat step 5 as ofter as needed
7. alter database open (if you get "statement processed" your 90% there
8. check date/timestamp on files at new location
9. check date/timestamp on files at old location New location should have current date/timestamp old location should have date/timestamp of when DB was shutdown
10. run a df (bdf in HP-UX) on the old file mount point
11. rm the datafiles, one at a time please
12. go back to step 10 as often as required, the df should show an increase in available space equal to the file just deleted (may have to run teh df several times depending on how the write cache behaves.

This has worked for me several times.

Dick Goulet

____________________Reply Separator____________________

Subject: moving data files on Unix
Author: Steff Gonos <steff_gonos_at_yahoo.com> Date: 8/31/00 7:14 AM

I need to move some data files from one disk to another. What is the best/simplest way to do this without destroying what I have out there. System is Solaris, oracle 8.1.5.

Should the instance be up and running ? Exclusive mode ?

Thanks.
Steff Gonos

---

---

 A day without sunshine is like, well, night.

---

Steff Gonos
steff_gonos_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

-- 
Author: Steff Gonos
  INET: steff_gonos_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 Thu Aug 31 2000 - 10:44:01 CDT