1. Login to SQL*Plus.
slqplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 4 09:43:57 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning and Data Mining options
2. Check the current log mode status.
SQL> select log_mode FROM v$database; LOG_MODE ------------ ARCHIVELOG
3. Shutdown the Oracle database.
SQL> Shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down.
4. Ensure all Oracle process were shutdown completely.
# ps -ef | grep ora
5. Mount Oracle database exclusively and not open for user connection.
SQL> startup mount; ORACLE instance started. Total System Global Area 1191182336 bytes Fixed Size 2020320 bytes Variable Size 603982880 bytes Database Buffers 570425344 bytes Redo Buffers 14753792 bytes Database mounted.
6. Set the Oracle database to NOARCHIVELOG.
SQL> alter database noarchivelog; Database altered.
7. Set Oracle database open for user connection.
SQL> alter database open; Database altered.
8. Verify the status
SQL> SELECT log_mode FROM v$database; LOG_MODE ------------ NOARCHIVELOG
