Database in archivelog mode

From: <murosa_at_bankinter.es>
Date: Thu, 21 Jun 2001 09:35:25 -0700
Message-ID: <F001.003321E2.20010621091551@fatcity.com>

     Hi folks.

     I have a very strange behavour in a database. I want to put database in archivelog mode, I've changed log_archive_start to true, log_archive_dest_1 to a location where I can write and log_archive_start to true. Then I follow next sequence:

          shutdown immediate;
          startup mount
          alter database archivelog;
          alter database open;
          alter system archive log start;

     In third step I get:

ERROR at line 1:
ORA-01126: database must be mounted EXCLUSIVE and not open for this operation.

     Next two sentence are executed correctly. When I select * from v$instance; I've got
SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------

HOST_NAME

---

VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------- --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE
---------- --- ----------------- ------------------

              2 webspher2
ebkppr02

8.1.6.3.0         21-JUN-01 OPEN    YES          2 STARTED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE

in both instance, because is an OPS.

     Initalization parameter remote_login_password is exclusive. I know that I have an error but I don't know which and why,
but it doesn't work in archivelog mode.

     Anybody can help me?.

     Thank you very much in advance.

     Miguel Urosa.

---

"Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato."

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: murosa_at_bankinter.es

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: ListGuru_at_fatcity.com (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). Received on Thu Jun 21 2001 - 11:35:25 CDT