Home » RDBMS Server » Server Administration » error setting arcive log distenations (Oracle 10g , unbreakable linux)
icon1.gif  error setting arcive log distenations [message #410508] Sat, 27 June 2009 14:16 Go to next message
samiraly
Messages: 51
Registered: June 2009
Member

i have set database in arcive log mode
with archive log start = true
after i set the arc files destinations data base can not be up
i set as folowing
aec_log_destination = /u01/arc1
aec_log_destination1= /u01/arc2
aec_log_destination2=/u01/arc3

i am using oracle 10.2.0 on unbreakable linux

i shutdown instance and when tried to bring it up again i got the following error

le@localhost onlinelog]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 26 21:04:13 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
SQL>



please advice
Re: error setting arcive log distenations [message #410510 is a reply to message #410508] Sat, 27 June 2009 14:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
archive_log_start doesn't serve any purpose for 10g+. And check ORA-16019.

Please follow the OraFAQ Forum Guide to learn how to format your post and check Oracle® Database Concepts 10g Release 2 (10.2) to learn about Oracle.
Re: error setting arcive log distenations [message #410545 is a reply to message #410508] Sun, 28 June 2009 08:09 Go to previous messageGo to next message
samiraly
Messages: 51
Registered: June 2009
Member

Thank you for your attention i think i should use backap for the spfile then changing the conflict

thank you for your advice
Re: error setting arcive log distenations [message #410546 is a reply to message #410508] Sun, 28 June 2009 08:42 Go to previous messageGo to next message
samiraly
Messages: 51
Registered: June 2009
Member

i cannot open database is there is any way to fix the spfile?
please advice
Re: error setting arcive log distenations [message #410547 is a reply to message #410546] Sun, 28 June 2009 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER SYSTEM

If you want to manage your database I recommend you to read Database Concepts and Administrator's Guide

Regards
Michel
Re: error setting arcive log distenations [message #410631 is a reply to message #410508] Mon, 29 June 2009 06:42 Go to previous message
samiraly
Messages: 51
Registered: June 2009
Member

Thank you very much issue resolved and here is the steps

1- created pfile from the current spfile
2- reverted the parameters changes done before
3- recreated spfile from the new updated pfile
4- issue resolved and database opened

thank you very much
Previous Topic: create new database
Next Topic: synonym translation is no longer valid
Goto Forum:
  


Current Time: Sun Dec 04 04:54:07 CST 2016

Total time taken to generate the page: 0.07401 seconds