Oracle отключаем archive log

На dev и test серверах archive log можно выключить.

При остановленной базе запускаем sqlplus

# sqlplus / as sysdba

 

SQL> archive log list
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     105
Next log sequence to archive   107
Current log sequence           107

 

SQL> startup mount

ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size            2932632 bytes
Variable Size          738197608 bytes
Database Buffers      327155712 bytes
Redo Buffers            5455872 bytes
Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     105
Current log sequence           107