How to close oracle archive log

Method: 1. Use the "select log_mode from v$database;" statement to check whether the current mode is archive mode; 2. Close the database and start it in the mount state; 3. Use the "alter database noarchivelog" command to close the archive Just log.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to close oracle archive log

Close the archive.

1 sql> archive log list; #Check whether it is the archive mode

2 sql> alter system set log_archive_start=false scope=spfile; #Disable automatic archiving

3 sql> ; shutdown immediate;

4 sql> startup mount; #Open the control file, do not open the data file

SQL> shutdown immediate;
   Database closed.
   Database dismounted.
   ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.
Total System Global Area 2572144640 bytes
Fixed Size                  2283984 bytes
Variable Size             738199088 bytes
Database Buffers         1828716544 bytes
Redo Buffers                2945024 bytes
Database mounted.

SQL>   alter database archivelog
  Database altered.

SQL>  alter database open

SQL>   archvie log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     88
Next log sequence to archive   90
Current log sequence           90

Oracle Video Tutorial"

The above is the detailed content of How to close oracle archive log. For more information, please follow other related articles on the PHP Chinese website!