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.

[Former Member]

Hi all,

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

I installed a second local hdd with 136GB 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.

I hav sapdba.....in both the systems....

Plz explain me the procedure for moving files to new hdd through windows explorer

Please help .....

Thanks in advance ,

Malti.

[Former Member]

Hi All,

Thanks all for ur replies....

Regards,

Malti

[Former Member]

Hi

Couple of options:

1) Windows:

--> If sapdata files are located in D:\oracle\SID\sapdata*, then why cant we add new HDD to D drive. If there is some issue in adding then the previous solution holds good

--> Else you can do a soft link using link.exe or junction.exe

2) UNIX: Use cross-link (ln command)

Regards

Madhu

[Former Member]

you have two additional options:

1. On Windows (windows 2000 or later) you can mount a disk to directory (see disk management, change/assign driveletter and paths in computer management.

2. use linkd.exe (part of windows server 2003 resource kit) to create junctions - similar to unix symbolic links.

peter

[former_member204746]

you can use BRTOOLS to do this. this way, you'll be sure that no manual steps were missed.

shutdown SAP

call brtools

options:

2 - Space management

6 - Move data file

fill option 3 or 4 and continue and follow instructions

[Former Member]

Hi Eric,

Thanks for ur reply...

All i wanted to do is ....

To create a new SAPdirectory in the new hdd and to make the sap system uses the new sap directory as its standard sap directory so what ever files are created they should sit in the new hdd standard sap directory.

Thanks in Advance,

Malti.

[former_member204746]

ok then, if on Windows:

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;

hope this helps.

[Former Member]

Malti:

Add the new HDD.

Create sap directories or folders sapdata1, sapdata2, etc.

Create new tablespace on and move large tables from old tablespaces to the new one created. The datafiles of the newtablespace will be located in the new HDD.

Thus you are reducing the size on the old HDD and then bigger and more used tables will be moved to the new HDD to grow.

-Madhu