How to check if Oracle is in archive mode

Method: 1. Use the "select name, log_mode from v$database" statement. If the displayed result is ARCHIVELOG, it is the archive mode. If the result is NOARCHIVELOG, it is the non-archive mode; 2. Use "archive log list" Statement view.

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

How to check whether Oracle is in archive mode

1. Select name,log_mode from v$database;

selectname,log_mode,open_mode from v$database;
NAME LOG_MODE OPEN_MODE
--------- ------------ -----------------
CKDB ARCHIVELOG READ WRITE

If it is archive mode, then LOG_MODE= ARCHIVELOG

If it is a non-archive mode, then LOG_MODE=NOARCHIVELOG

You can also use the following statement

2, archive log list; (This method requires as sysdba)

View oracle log mode:

archive log list

Expand knowledge:

Modify oracle Log mode:

1, close the database: shutdown immediate;

2, start the database instance to the mount state: startup mount;

3, switch the database log mode:

alter database archivelog; (Set the database to archive log mode)

alter database noarchivelog; (Set the database to non-archive log mode)

4, open the database: alter database open;

5, confirm that the database is in archive mode: archive log list;

Recommended tutorial: "Oracle Video Tutorial"

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