[Discuss] Oracle 11G question

[dsr at randomstring.org (Dan Ritter)]

On Fri, Apr 05, 2013 at 07:41:27AM -0400, Jerry Feldman wrote:
> Currently my Oracle installation data directory is at 90% allocated
> space on a 500GB physical partition in a VM. When the system was
> created last year, the company DBAs set up the specs. Unfortunately
> the DBAs are Canadian and are now not allowed to do any IT work in
> the US. Politics aside:
> The system is organized where /oracle contains  the Oracle binaries
> and /oradata contains the data
> 
> What I would like to do is:
> 1. shutdown the listeners and console
> 2. allocate a 1TB vdisk and mount it onto /oradata.new. I'm thinking
> of using LVM so that I can add more space by adding another logical
> volume.
> 3. copy all the bits from /oradata to /oradata.new
> 4. unmount /oradata
> 5. remount /oradata.new onto /oradata
> 6. restart oracle
> 
> The question I have is does Oracle do anything physical such that by
> moving the data to another physical volume would cause a problem.

Not if it's working as described, no. Moving files to a new
filesystem mounted in the same place is fine.

-dsr-