Hi all,

My database is running of oracle 10g. My archive log sequence crossed the 5 digits. Now to make it of 6 digits i modified my parameter in init.ora and spfile using following steps:

shutdown immediate
set parameter in init.ora to log_archive_format='%t_dbname_%s_%r.ARC'
startup pfile='path\init.ora'
create spfile from pfile='path\init.ora';
shutdown immediate
startup

Now when I start the database it generates archive log sequence with 6 digits. But when I again restart the database it again start generating archive log sequence with 5 digits.
And parameter in spfile shows parameter automatically converted to '%T_CWHODDB_%S_%R.ARC'

So how to stop database to automatically convert the log_archive_format in spfile? I do not want to open database with resetlogs.

Help is appriciated.

Thanks and regards
Keyur Dave