Data Path Change Oracle.

[Former Member]

I want to add Hard Disk to existing system and change the path of existing Data both SAPDATA1 and Oraarch for additional Space

System is ECC5 IDES/Oracle 9.2/Win2003.

Present path D:\Oracle\SID\oraarch

E:\Oracle\SID\SAPDATA1

New Path E:\Oracle\SID\Oraarch

F:\Oracle\SID\SAPDATA1

Someone can help me with exact procedure.

Thanks,

[Former Member · Accepted solution]

Ho Manssor,

If the number of datas too many and you think moving one-by-one using brtools can take alot of time. There is still one sulution to use, but this is litter risky.

Here the step.

1. SQL > alter database backup controlfile to tracefile; (dont type SQL >, its sqlplus command prompt)

2. Goto /oracle/<SID>/trace/usertrace (see the newest trace file)

3. Copy the file to some where

4. Open the file and get only the part your want (RESET or NOT RESET) choice only one.

5. Change all the path E:\Oracle\SID\SAPDATA1 to F:\Oracle\SID\SAPDATA1,

you can use find & replace.

6. rename the file to control.sql

6. Copy all the file to the new path (dont move, later delete it after every run ok)

7. Apply the new control file by running the control.sql from sqlplus

8. SQL > @control.sql (dont type SQL >, its SQL command prompt)

9. If every thinkg ok than you finish move the path.

But once again this is step is a bit riskly as you playing with the oracle control file, and this can cause your database can't startup due to the error in control file.

Please make sure you backup the control file and your database before do any thing.

Regards,

Fendi Suyanto

[Former Member · Accepted solution]

Fendi,

Changes to database controlfile will need the database to be in mount state. You cannot modify database control file when the database is open.

Cheers,

Nisch

[Former Member · Accepted solution]

Hi Nisch,

Yes you are right, I forget to mention about the database state.

Here additional information for the database state:

During creating the backup control file, database mush in OPEN (start) state

During apply the control.sql, database mush shutdown first.

Regards,

Fendi Suyanto

[Former Member]

I agree, when creating new files use the path F:\Oracle\SID\SAPDATA1

and the older datafiles continue to exist on E:\Oracle\SID\SAPDATA1

Unless you want to crash E:\ disks...

[Former Member]

If the idea is to add additional space, there is no need to change existing path. Once the new disk is added, allocate space for SAPDATA1 and ORAARCH on the new disk.

If the idea is to relocate the files, follow Eric's suggested procedure.

Thanks.

BMG

[former_member204746]

use BRTOOLS to move datafiles from one disks to another. SAP will need to be down for this to work.

brspace -c -u / -f dfmove -f (path of source file) -d (destination of file)

as for ORAARCH, change LOG_ARCHIVE_DEST ini init[SID].ora to new value and restart Oracle.

[Former Member]

Hi,

I think you need to change environment variable too apart from the procedure Eric has suggested.

Regards,

Payal