Re: moving data files on Unix

1. Shutdown the database
2. From unix cp the data files to their new location. DO NOT USE MV!
3. startup mount. Don't open the database at this point.
4. for each file you want to move - ALTER DATABASE RENAME FILE 'old file' TO 'new file';
5. shutdown and restart
6. Log in and check DBA_DATA_FILES to check that all is well and you moved everything.
7. Only at this point should you delete the old data files.
8. Take a backup or as a minimum backup your control file.

Hope this helps

Allan
----- Original Message -----
From: "Steff Gonos" <steff_gonos_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 31, 2000 10:14 AM Subject: moving data files on Unix

> 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 - 22:28:29 CDT