ORA-32006: %s initialization parameter has been deprecated

ORA-32006: %s initialization parameter has been deprecated

ORA-19905: log_archive_format must contain %s, %t and %r

while startup(Archivelog mode) the following message dispalyed

ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated.

how to solve this problem ?

Just remove this parameter from your Initialization Parameter File (INIT.ORA/ SPFILE).

log_archive_start parameter is deprecated from 10g. LOG_ARCHIVE_START parameter is no longer required to be set in order to run the database in ARCHIVELOG mode. This parameter is deprecated in Oracle 10g. If you put this parameter in your init of spfile, database will start, but will get following error.

ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated ORACLE instance started.

However, if we change the LOG_ARCHIVE_FORMAT to something other than the default %s,%t,%r, it will fail. and you get following error.

ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated

ORA-19905: log_archive_format must contain %s, %t and %r

Could not startup the database in mount / nomount stage using Spfile as Spfile had wrong format for archive log.

To implement the solution, please execute the following steps:

1. Create a copy of the init.ora file. ( oracle_home/admin/pfile --> init.ora )

2. Edit the above init.ora to reflect the log_archive_format = 'arch_%r_%t_%s.arc'

and log_archive_dest_1 = f:\archive

3. Shutdown immediate and Startup nomount with the above pfile.

shutdown immediate

startup nomount pfile = oracle_home/admin/pfile/init.ora

4. Create spfile from pfile

create spfile = 'oracle_home/database/spfile.ora' from pfile ='oracle_home/admin/pfile/init.ora'

5. shutdown immediate

6. startup

7. archive log list --- verify that db is in arhivelog mode.