[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1438
  • Last Modified:

ORA-32004: obsolete and/or deprecated parameter(s) specified Error after switching to archivelog mode in Oracle 11G.

Hi,

I'm using Oracle 11g   in Windows 2008 Server.

After switching the  database to archivelog   mode with the script below,   while starting up
it gives the Error '  ORA-32004: obsolete and/or deprecated parameter(s) specified' .
By applying ths script , the database  is  successfully switched to  archivelog mode and also starts up successfully.
But why does this error message  occur ?   and  How can I handle this?

The archivelog mode script is ;

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
alter database archivelog ;
ALTER DATABASE OPEN;
alter system set log_archive_start=true scope=spfile;
alter system set  log_archive_format='arc_%t_%s_%r.arc' scope=spfile;
alter system set archive_lag_target=3600 scope=both;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=60G;
shutdown immediate ;
startup;
0
orcun_turkec
Asked:
orcun_turkec
  • 2
1 Solution
 
LindaCCommented:
Hi, starting with Oracle Database 10g Release 1 (10.1), the LOG_ARCHIVE_START initialization parameter has been deprecated. Archiving is now automatically started when the database is placed in ARCHIVELOG mode.
0
 
orcun_turkecAuthor Commented:
Thank you...
0
 
orcun_turkecAuthor Commented:
Now, it doesn' t give error message and works in archivle log mode.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now