how to resolve the below warning prompted in alert log file oracle.
I had encountered the below error in production database.
My production database version is 10.2.0.4.0
ARC0: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ACTION: this error occurs if you have set the log_archive_format parameter in UPPER CASE.
i had set the parameter format as 'ARC%S_%T_%R'.
to resolve this error simply set the log_archive_format parameter in lower case as
alter system set log_archive_format='ARC%s_%t_%r' scope=spfile;
then restart or bounce the database to make the changes effective in session as well since the log_archive_format parameter is static parameter.
I had encountered the below error in production database.
My production database version is 10.2.0.4.0
ARC0: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
ACTION: this error occurs if you have set the log_archive_format parameter in UPPER CASE.
i had set the parameter format as 'ARC%S_%T_%R'.
to resolve this error simply set the log_archive_format parameter in lower case as
alter system set log_archive_format='ARC%s_%t_%r' scope=spfile;
then restart or bounce the database to make the changes effective in session as well since the log_archive_format parameter is static parameter.