Para desactivar el modo archive log de nuestra base de datos, debemos iniciar bajando la base de datos.
[oracle@soyundba ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon May 17 15:17:28 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Iniciamos la base de datos en estado mount (montado)
SQL> startup mount
ORACLE instance started.
Total System Global Area 1787138048 bytes
Fixed Size 2254104 bytes
Variable Size 486542056 bytes
Database Buffers 1291845632 bytes
Redo Buffers 6496256 bytes
Database mounted.
Alteramos la base de datos, para cambiar a No Archive Mode (No archive log)
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
Ahora abrimos la base de datos
SQL> ALTER DATABASE OPEN;
Database altered.
Podemos validar el modo de recuperación de nuestra base de datos
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /arclog/soyundba
Oldest online log sequence 1
Current log sequence 2
Para configurar base de datos Oracle en modo archive log, puedes ver este articulo
