Re: Noarchivelog ==> archivelog

Hi,
If it's one instance of OPS or RAC ,you should set parallel_server=no or cluster_database=false,then 'startup mount' ,'alter database archivelog;',and you can change them back once archive log working.

Zhai

tamizh_at_optonline.net wrote:

>Hi List,
>
>Could someone help me to figure out what is going on here?
>I am trying to change db from NOARCHIVELOG --> ARCHIVELOG.
>
>
>SQL> archive log list
>Database log mode No Archive Mode
>Automatic archival Enabled
>Archive destination /u02/arch
>Oldest online log sequence 966
>Current log sequence 968
>
>SQL> shutdown
>Database closed.
>Database dismounted.
>ORACLE instance shut down.
>
>SQL> startup mount
>ORACLE instance started.
>
>Total System Global Area 1409298592 bytes
>Fixed Size 73888 bytes
>Variable Size 374722560 bytes
>Database Buffers 1024000000 bytes
>Redo Buffers 10502144 bytes
>Database mounted.
>
>
>SQL> alter database archivelog;
>alter database archivelog
>*
>ERROR at line 1:
>ORA-01126: database must be mounted EXCLUSIVE and not open for this operation
>
>Thanks
>Sami
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Zhai Jingmin
  INET: jmzhai_at_staff.oos.com.cn

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).