cancel
Showing results for 
Search instead for 
Did you mean: 

Names of Oracle Redo logs

Former Member
0 Kudos

Hi!

Since we copied SAP system and execute the redo log backups our redo log s have the following convention:

- ARCH02000_070438484190.001

We would like to have instead the other convention:

- <sid>ARCH02000_070438484190.001

Quesiton:

1) Which parameter is responsible for this setting?

2) Which file (init<sid>.ora, other) other tools (e.g. brtools) should be edited therefore?

Thank you!

regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

1) Which parameter is responsible for this setting?

log_archive_format='%t_%s_%r.dbf'

2) Which file (init<sid>.ora, other) other tools (e.g. brtools) should be edited therefore?

spfile<SID>.ora

You should change this parameter using BRTools..

1. Instance Management --> 7 - Show database parameters

Then select the parameter log_archive_format and modify the parameter as '%t_%s_%r.dbf'

Thats it...

Regards.

Rajesh Narkhede

Former Member
0 Kudos

Many thanks for the reply!

The parameter "log_archive_format" is set to "ARC%S%R%T".

I compared this settings with other SAP systems and seems to be the same, but on other systems the redo logs have the other convention with <sid> before.

Any idea how to solve this problem?

Thank you!

Former Member
0 Kudos

hi,

you can change the format that is <sid>ARC%S%R%T.

thanks

ferhan

Former Member
0 Kudos

Thank you!

The question still is:

the value for log_archive_format is the same for all SAP systems and is ARC%S_%R%T.

On all systems excepting one the redo logs are <sid>ARC....

When I try to execute the following commando:

ALTER SYSTEM set log_archive_format=FI1ARC%S_%R%T scope=spfile:

The error is:

invalid character FI1ARC%...

volker_borowski2
Active Contributor
0 Kudos

Hi Holger,

the complete name is concatenated from

log_archive_dest

or

log_archive_dest_1

and

log_archive_format

The recommended Parameters are

log_archive_dest_1='LOCATION=/oracle/SID/oraarch/SIDarch'

log_archive_format='%t_%s_%r.dbf'

which result in

/oracle/SID/oraarch/SIDarch%t_%s_%r.dbf

with %t expanded to the treadinstance and usually will be just "1"

and %s beinig expanded to the sequence number

and %r being expanded to the resetlogsid

So I'll guess your setup is

log_archive_dest=/oracle/SID/oraarch/SID

log_archive_format=' ARC%S_%R%T'

And the one system that is diffrent just has

log_archive_dest=/oracle/SID/oraarch/

> When I try to execute the following commando:

>

> ALTER SYSTEM set log_archive_format=FI1ARC%S_%R%T scope=spfile:

>

Try it with quotes around it. The "percent" is a special char to sql.

ALTER SYSTEM set log_archive_format='FI1ARC%S_%R%T' scope=spfile

Volker

volker_borowski2
Active Contributor
0 Kudos

Hi,

this would be

log_archive_dest_1="LOCATION=/oracle/SID/oraarch/SIDarch"

log_archive_format="%s_%r.%t"

allthough the SAP convention would be

log_archive_format='%t_%s_%r.dbf'

Volker