OraFAQ Forum: Server Administration » error setting arcive log distenations

Home » RDBMS Server » Server Administration » error setting arcive log distenations (Oracle 10g , unbreakable linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error setting arcive log distenations [message #410508]

Sat, 27 June 2009 14:16

samiraly
Messages: 57
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

Report message to a moderator

Re: error setting arcive log distenations [message #410510 is a reply to message #410508]

Sat, 27 June 2009 14:40

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.

Report message to a moderator

Re: error setting arcive log distenations [message #410545 is a reply to message #410508]

Sun, 28 June 2009 08:09

samiraly
Messages: 57
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

Report message to a moderator

Re: error setting arcive log distenations [message #410546 is a reply to message #410508]

Sun, 28 June 2009 08:42

samiraly
Messages: 57
Registered: June 2009

Member

i cannot open database is there is any way to fix the spfile?
please advice

Report message to a moderator

Re: error setting arcive log distenations [message #410547 is a reply to message #410546]

Sun, 28 June 2009 09:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: error setting arcive log distenations [message #410631 is a reply to message #410508]

Mon, 29 June 2009 06:42

samiraly
Messages: 57
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

Report message to a moderator

Previous Topic:	create new database
Next Topic:	synonym translation is no longer valid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 17:32:40 CST 2024