Moving sap directory to new hdd

[Former Member]

Hi all,

The problem I am having is my root disk is getting full .

I installed a second local hdd with 136 of space. What is the best way to move sap directory to the new hdd? Of course the files will still have to keep all permissions etc. So, that the files that sap uses the new directory in the new hdd.

Please help .....

Thanks in advance ,

Malti.

[Former Member · Accepted solution]

Hi,

Plz tell me if the do the following ..will i b successful..

First i will create the Oracle folder...

then SID ...

then in that i will create mirrorlogs,saparch,sapbackup,sapdata1,sapdata2,sapdata and other folders..

Secondly I will just change the drive letter to D.

1.If i do this i even i hav to change the original D drive to someother name right?

2.If i do this i shall i need to copy all the files in ora81(home) to the new hdd?

I am workin on 4.6 n 4.7 n i dont hav brtools but i hav sapdba......with wt options i can do the foll..?

please help me..

Thanks in Advance,

Malti

[former_member204746 · Accepted solution]

your source folder was on the C drive and you want to move to the 😧 drive?

then follow my commands I gave you earlier:

shutdown SAP

then:

sqlplus "/ as sysdba"

alter database backup controlfile to trace as 'C:\trace.sql'

shutdown immediate;

exit;

move file using Windows Explorer.

now, edit C:\trace.sql' and change the drive letters to the new one.

delete all lines beginning with --

delete empty lines

after the first list of datafile, you will find (or similar):

CHARACTER SET WE8DEC

;

delete all the lines floowing the semi-colon and save the file

now, execute:

sqlplus "/ as sysdba"

@c:\trace.sql

shutdown immediate;

startup;

[Former Member · Accepted solution]

No Malti,

If you just do this it doesnt solve the problem.

What I understand from your problem is that your HDD is filling up to 100% due to increse in databse size and hence you want to add another disk and move ur database to the new place.

For this, You need not move the whole data or the database from one disk to the otehr disk. All you need to do is extend the databse to the new hard disk you add. And you can do this by creatign new tablespaces like for example if you have PSAPBTABD on C drive and you adding D drive then create tablespace ZPSAPBTABD and move couple of big tables from PSAPBTABD to ZSAPBTABD. this is called as table move. Once you do this then u get space o nyour C drive since tables are moved.

And in future your databse grows on D drive depending on the tables you moved.

Hope you understood the process.

-Madhu

[Former Member · Accepted solution]

Hi Eric,

Thanks for ur replies...

Should i follow this procedure only for trace file ya even for all the files which i want to move...including oracle home and SID.

(The database is Oracle)

Thanks,

Malti

[former_member204746 · Accepted solution]

this procedure will work, you do not plan on moving oracle binaries?

you may also want to adapt initSID.ora for a few paths.