How to turn off Archivelog Mode

Database Version           : 11gR2 StandAlone

OS                                  : Linux 5

1.     Shutdown the database in immediate mode. If the database is shutdown in abort mode, then start the database and shutdown again in immediate mode.

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

ORCL      READ WRITE

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     23

Next log sequence to archive   25

Current log sequence           25

SQL>

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

2.     Start the database in mount mode.

SQL> startup mount

ORACLE instance started.

Total System Global Area  313860096 bytes

Fixed Size                  1336232 bytes

Variable Size             255855704 bytes

Database Buffers           50331648 bytes

Redo Buffers                6336512 bytes

Database mounted.

SQL>

3.     Turn off the archivelog mode for the database.

SQL> alter database noarchivelog;

Database altered.

SQL>

4.     Open the database.

SQL> alter database open;

Database altered.

SQL>

5.     Check that the database is running on no-archive log mode.

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

ORCL      READ WRITE

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     23

Current log sequence           25

SQL>