Solved

move oracle-sap db

Posted on 2015-01-19
3
166 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
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 34

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now