Re: Moving datafiles on NetApp

From: Wayne Smith <wts_at_maine.edu>
Date: Sat, 11 Oct 2014 03:28:10 -0400
Message-ID: <CAEgY-F4Qg45ufgjOCJCiV7xm_gNRhMux7=R=L8TdTU-1Po2SXg_at_mail.gmail.com>

On our Linux and Solaris systems, I've moved files (w/db down) and created sym links where the files used to be.

One can do OS move and do a database rename to tell Oracle where they are now.

Doesn't v12 allow rename/move of live data files, or am I falling into the trick part of the 11.2 question?

Cheers, Wayne
 On Oct 8, 2014 5:26 PM, "Jimmy Brock" <jimmybrock_at_gmail.com> wrote:

Using Oracle 11gR2, not using DNFS.

Currently, all of our data files are stored on the same volume on the NFS server. I need to move all the application data files to another volume; separate from the system data files. Can this be done in Oracle? Or do I need to involve the storage admin to move the files?

I plan on taking backup before we do this, just in case. But I believe I can rename the files while in mount mode, after we physically move the files on NetApp.

--

Jimmy Brock

--

http://www.freelists.org/webpage/oracle-l Received on Sat Oct 11 2014 - 09:28:10 CEST