Disable Archive Log

  1. Check Status and Parameters.

  2. Shutdown and startup mount (!Caution).

     [oracle@orcl ~]$ sqlplus / as sysdba
    
     SQL> shutdown immediate;
     Database closed.
     Database dismounted.
     ORACLE instance shut down.
     SQL> startup mount
     ORACLE instance started.
    
     Total System Global Area 1577055400 bytes
     Fixed Size                  9135272 bytes
     Variable Size             939524096 bytes
     Database Buffers          620756992 bytes
     Redo Buffers                7639040 bytes
     Database mounted.
     SQL>
    
  3. Disable archivelog:

     SQL> alter database noarchivelog;
    
     Database altered.
    
  4. Open database:

     SQL> alter database open;
    
     Database altered.
    
0
Subscribe to my newsletter

Read articles from Martyn Rangel Figueiredo directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Martyn Rangel Figueiredo
Martyn Rangel Figueiredo