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: [EMAIL PROTECTED] 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: [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). ______________________________________________________________________________ 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: [EMAIL PROTECTED] 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: [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).
