parameteres oracle do not set

[Former Member]

Hi,

I´ve following the note 830576 - Parameter recommendations for Oracle 10g

In the point of the parameters i´ve found several of them that have to be the state DO NOT SET.

For example;

LOG_ARCHIVE_DEST Do not set!

What can i do?

More thanks

[Former Member · Accepted solution]

set the below parameter

LOG_ARCHIVE_DEST1

[Former Member · Accepted solution]

Could you guide me with the steps?

More thanks

[Former Member · Accepted solution]

Try these commands:

alter system reset log_archive_dest scope=spfile;

-- resets the log_archive_dest parameter

alter system set log_archive_dest_1="LOCATION=/oracle/<SID>/oraarch/<SID>arch"
scope=spfile;

-- set the new path for log_archive_dest_1.

After that restart your db and check that switching the log files works as expected.

Kind regards,

[Former Member · Accepted solution]

Thanks SVEN DINTER,

What is the difference about log_archive_dest and log_archive_dest1?

[Former Member · Accepted solution]

Hi Ruben,

They do about the same function, however....

WIth log_archive_dest set you cannot set any of the log_archive_dest_n parameters...

Also with log_archive_dest_n you can send archive logs to remote standby databases......

Ex : alter system set log_archive_dest_2 = 'SERVICE=<service defined in tns>

Hence, you can ship logs generated from one databases to multiple standby databases

Thanks,

Salman

[Former Member]

Dear,

The best thing what you can do to understand what needs to be set and what not.

Go to note 1171650 in the attachment section. Based on your oracle version open and copy the content

Login to your SAP System

SA38

run report RSORADJV

paste the copied content and execute.

It will show a report what parameters needs to be set on your SAP system.

Regards

Iliyas

[Former Member]

Hi ,

You need to reset those parameters...

About, log_archive_dest,

If you set this parameter, you cannot use log_archive_dest_n parameters.....

Thanks,

Salman

[Former Member]

Hi,

I´ve reset the parameter log_archive_dest, and the system is not creating archivelog. The system ins in mode ARCHIVE ON.

What can i do?

[nirmal_konchada]

Those parameters are not required to set as they had been already set or removed.

Like dont set LOG_ARCHIVE_DEST as its replaced with LOG_ARCHIVE_DEST1

Regards,

Nirmal.K