-
Hi,
When I am trying to open my database it is giving me the following error.
SVRMGR> alter database open;
alter database open
*
ORA-00255: error archiving log 4 of thread 1, sequence # 4
ORA-00312: online log 4 thread 1: 'C:\ORA805\DATABASE\LOG1ORCL.ORA'
ORA-00294: invalid archivelog format specifier 'O'
SVRMGR>
Initialization Parameters
---------------------------
log_archive_dest = %ORACLE_HOME%\database\archive
log_archive_format = %ORACLE_SID%%S.%T
log_archive_start = TRUE
Please suggest
Thanks
Anurag
-
as it suggests it does not recognise the %ORACLE_HOME% in the log_Archive_format
I think % expects only following characters that have a special meaning --
s,S,t,T
So Change your parameter to --
log_archive_format = Arch%S.%T
or if you must add the SID_Name then hard code it --
log_archive_format = MySid%S.%T
- Rajeev
-
Hi Rajeev,
I changed the initialization parameter so that it looks like
log_archive_format = Arch%S.%T
and it worked.
But my question is why did it not recognize the
%oracle_sid%. Moreover that format was created by oracle database configuration assistant as default when i said that enable archiving while creating the database.
Thanks
Anurag
-
This is a Bug: 723315 and it is fixed in 8.0.6.
It only appears in 8.0.5, 8.0.4 doesn't have this problem
