on 03-16-2010 3:45 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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%...
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.