Oracle-L: RE: Noarchivelog ==> archivelog

From: Nelson, Allan <anelson_at_midf.com>
Date: Tue, 28 Oct 2003 11:49:25 -0800
Message-ID: <F001.005D4D3E.20031028114925@fatcity.com>

Startup nomount
Alter system enable restricted session;
Alter database mount exclusive;

-----Original Message-----
Sent: Tuesday, October 28, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L

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:
INET: tamizh_at_optonline.net

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).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

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

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------