Solved

move oracle-sap db

Posted on 2015-01-19
3
184 Views
Last Modified: 2015-01-20
I have an sap-oracle 10g db mounted in redhat linux 5 on sdb5 /oracle/SID I'm getting out of space and I don't have slots on this server to add more hard disk, in addition I can't have to many dead time for this db , I was wondering If I can mount a nfs with the same mount point: nfs x.x.x.x  /oracle/SID and temporary move the db to this partition and the system (SAP) won't notice the change of the location, with this I will get enough time to change the hard disk in the original server, mount it and do the reverse procedure to return the db to the original mounted hard disk but now with enough space.
0
Comment
Question by:MikeRomo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Expert Comment

by:SagiEDoc
ID: 40559526
You can move data files to a nfs share. You will need to modify the config files with the location of the data files. Performance will also not be great.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 40559743
Yes, an Oracle database will allow you to move parts or all of it to alternate disk location(s). And the application (SAP in your case) won't know or care where the actual Oracle database files are.  Whether performance will be better or worse, will depend on your hardware.  

Some of these moves can be done without any database downtime.  These moves include: the "temp" tablespace(s); the on-line and archived redo log files; the directory where "trace" files get written; the directory where database backups get written, etc.  If you want to move some of the actual "data" files of the database, this will require application and database down time.  After a graceful shutdown of the Oracle database, you can simply use O/S commands to copy one or more Oracle database files to a different disk location, then for each file you copied, you use:
"alter database rename [old file path and name] to [new file path and name];" commands, then restart the database, make sure there are no errors reported in the database alert.log file, then restart the application.
0
 

Author Closing Comment

by:MikeRomo
ID: 40559815
thanks!!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question