Less space in SAP Server - Need to migrate to New Drive

[Former Member]

Dear All,

My SAP Server is installed in E Drive. Oracle 10G is also installed in the same drive.

And now only 10 GB space in E Drive is left.

I have a new Hard Disk with 500 GB space.

I would like to know how can resolve this problem. What should i do in this case? and how to do?

1. Should I delete old Logs/data from SAP server... IF yes, then how to do it.

2. Should I migrate the old data to new drive.. Again how to do it?

3. How to set path to new drive so that newly create data should automatically come in new drive... please suggest.

P.S. I am not a BASIS Consultant...

[Former Member]

Hi,

You can follow the below procedure to incur new drive with existed datafiles :-

1. Map  a new drive in your server named for example F: .

2. Then turn off SAP instances and database services and take a database backup of that server with any third party tool or directly through oracle (Follow this link for your reference http://docs.oracle.com/cd/B19306_01/backup.102/b14192.pdf)

3. After taking the dump, restore the same (do system copy) with the help of SAP INST of your version.

Don't forget to give the path of installation in new drive (i.e. F:)

4. In case any database inconsistency received , use SWPM to synchronize all database binaries.

Regards,

Nilutpal.

[former_member185239]

Hi Suruchi,

You can move the database to the hard disk (new location) my renaming the datafile.

Please follow the below link

http://www.oracle-base.com/articles/misc/renaming-or-moving-oracle-files.php

Also let me know the usage of SAP

With Regards

Ashutosh Chaturvedi

[Former Member]

The simplest thing to do would be to connect the new drive as, say, drive F, copy all the contents of drive E to drive F, and then swap the drive letters so that the new drive is drive E. Do this with both SAP and Oracle shut down.

There's nothing in the Oracle or SAP config tying them to the physical drive, so as long as the drive letter remains the same everything should start up just fine afterwards. The only difference will be the extra space.

And 's advice is good also - if you're not sure about all this then find somebody who is.

Steve.

[JPReyes]

Depends on the scenario, you could simply move some of the datafiles to your new drive or do a full Homogeneous System Copy to replace the whole drive.

P.S. I am not a BASIS Consultant...     

You should get one!

Regards, Juan