Set Oracle to NOARCHIVELOG mode

Share this article :

1. Login to SQL*Plus.

slqplus "/as sysdba"
SQL*Plus: Release - 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 - 64bit Production
With the Partitioning and Data Mining options

2. Check the current log mode status.

SQL> select log_mode FROM v$database;


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;


Related posts

Difference: Oracle Session & Oracle Connection
Change User Password in Oracle
How to Locate Oracle Mirror & Orig Log Files
How to Find / List Available Schema in Oracle
© 2018 ITsiti. All Rights Reserved
Powered by KEEM