How to modify the archive mode in oracle

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 archivelog;" command to modify Just set it to archive mode.

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

How to modify the archive mode in oracle

Switch to the oracle user, and then use sqlplus /nolog to log in to the oracle data

Use the oracle system administrator sysdba to log in to the database

conn /as sysdba

View the current oracle mode

select log_mode from v$database;

The current mode is NOARCHIVELOG and the archive mode is not turned on

select * from v$archive_processes;

Obviously there is no automatic archiving, no archiving process, let alone archiving mode.

Close the database and boot to mount state

shutdown immediate

startup mount

Modify the database to archive mode

alter database archivelog;

Verify again that Oracle has been modified to archive Mode

Recommended tutorial: "Oracle Video Tutorial"

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