Path for oraarch and origlogX directories

[Former Member]

Hi all,

I have the need to change the installation path of some Oracle 10.2.0.2 directories. These are origlogX and oraarch.

In fact I do not change the path during sap installation, and now my systems create continuously logs, fulling up my Windows partition.

Is there a manner to perform this change?

My sap systems will be damaged?

Have I to perform some changes in profile parameters?

Thanks a lot to all!

Regards

Daniele

[former_member185954 · Accepted solution]

Hi,

For changing oraarch location and changing archiving settings, please check this link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/92fdd1fada9e4d87be08c217639c1f/frameset.htm

Regards,

Siddhesh

[Former Member]

Can we resize online redo log without dropping and recreating. I mean can we alter the size of online redo log files. If yes how ?

Regards

Waqas

[Former Member]

[quote]

Can we resize online redo log without dropping and recreating. I mean can we alter the size of online redo log files. If yes how ?

[/quote]

no you can't

drop 1 log

create 1 new log

repeat

switch logs

drop last remaining old one

create new one

done

sap note 3809 is still valid for this

[former_member185954]

For moving Online Redo logs altogether, check this link:

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/onlineredo.htm#512

Regards,

Siddhesh

[former_member185954]

Hi,

You can change the location via Enterprise manager.

Details about your data and log files are stored in the control file.

Regards,

Siddhesh