Move saparch directory

[Former Member]

How do I move the saparch and sapbackup directories without affecting the database operations? I am running Windows 2003 / Oracle 10.2.0.2. I have already created the new directories where I need them to be (on the K:\ drive) and changed the environment variables in Windows. What else do I need to do to make the change complete?

Thanks,

-- Jackie McCarty

[Former Member]

I should mention that my logs go to \oraarch\RD2arch, saparch is for the brarchive logs (If I understand it correctly).

[stefan_koehler]

Hello Jackie,

i am sorry, but Eric is not 100% correct.

Regarding to sapnote #830576 the parameter LOG_ARCHIVE_DEST should not be set.

If you read the parameter documentation, you can "understand" why:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams099.htm#i1128645

For Enterprise Edition users, this parameter has been deprecated in favor of the LOG_ARCHIVE_DEST_n parameters
...
To override the destination that this parameter specifies, either specify a different destination for manual archiving or use the SQL*Plus statement ARCHIVE LOG START filespec for automatic archiving, where filespec is the new archive destination. To permanently change the destination, use the statement ALTER SYSTEM SET LOG_ARCHIVE_DEST = filespec, where filespec is the new archive destination.

As you have set the correct parameter LOG_ARCHIVE_DEST_<N>, you can change this dynamically.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams100.htm#I1010086

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams101.htm#i1128799

For more information howto change the parameter "on-the-fly" .. please check metalink note #160446.1.

Regards

Stefan

[former_member204746]

check initSID.ora for archive_log_dest to see if it write in the saparch directory. if this is the case, change that to a new oraarch directory.

I wuold also have a look in file initSID.sap and initSID.utl if using a 3rd-party backup program.