Monday, April 7, 2008

ORA-07283/ORA-32004: obsolete and/or deprecated parameter(s) specified

Error Description:
while startup your database it raise an error like,

ORA-19905: log_archive_format must contain %s, %t and %r
Explanation of Error:
Could not startup the database using Spfile as Spfile had wrong format. Some/Al least one parameter in it is obsolete and/or deprecated.

Solution:
1)start the database in nomount state:
Try with startup nomount.

If you fail,then see section a).
If you succeed then follow section b)

a)If you fail to startup nomount stage(You will fail if static parameter is wrongly set.) like,
ORA-19905: log_archive_format must contain %s, %t and %r then,

i)Create a copy of the init.ora file. ( oracle_home/admin/$ORACLE_SID/pfile --> init.ora ) or you don't have a copy then you must have to create a new pfile.

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

iii)Shutdown immediate and Startup nomount with the above pfile.

SQL> shutdown immediate
SQL> startup nomount pfile = oracle_home/admin/$ORACLE_SID/pfile/init.ora

iv)Create spfile from pfile
SQL> create spfile from pfile ='oracle_home/admin/pfile/init.ora'

v) SQL> shutdown immediate
vi) SQL> startup


b)You succeed but with an error like,
ORA-32004: obsolete and/or deprecated parameter(s) specified

i)See alert log to see which parameter has been obsolete and/or deprecated parameter. Find the parameters. Set the parameter / reset the parameter.

Like,

SQL> alter system reset log_archive_start scope=spfile sid='*';

ii)shutdown immediate


iii)startup
2)Alter database mount.

3)Alter databse open.
If you face the error like

ORA-07283: sksaprd: invalid volume size for archive destination.
then,

SQL> alter system reset log_archive_dest scope=spfile sid='*';

No comments:

Post a Comment