Dennis, Did you specify "scope=both" when running "alter system ...."?
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 1:48 PM > Thanks to everyone for the ideas on the init.ora. You were correct that the > answer is indeed with spfile. Now I have discovered a catch-22. > > Oracle 9.2, Solaris > > 1. If spfile is created with LOG_ARCHIVE_START = true, > database will not start. Receive the error > ORA-00439 feature not enabled: Managed Standby > 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database > starts. Issuing > ALTER SYSTEM ARCHIVE LOG START > works, but it isn't changed in the spfile, so the next time Oracle is > bounced, the archiver doesn't start. > > This is starting to smell like a bug, but I thought I'd run it past the list > on the off-chance someone else has gotten archiving turned on for 9.2. > Thanks. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
