Set Oracle to NOARCHIVELOG mode



Share this article :

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

Related posts

Start & Stop Oracle Listener
Difference: sqlplus /nolog & /as sysdba
Find Oracle User Created Time
Steps to Patch Oracle 10.2.0.4.0 to 10.2.0.5.0
© 2017 ITsiti. All Rights Reserved
Powered by KEEM