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.
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!