Oracle 11g R2 Management archive log files

There are two ways to run an Oracle database: Archive (ARCHIVELOG) and non-archive (NO ARCHIVELOG). In non-archive mode, the log switch overwrites the previous redo log files directly and does not generate an archive log. The database runs under archive mode, and after the log switchover, the arch process archives The full redo log file, which, by default, runs in a non-archive mode, primarily because of the performance issues that the archiving system brings. The arch process exists only when the database is running in the archive mode. The arch process is an optional background process for Oracle, which archives the logs to save all changes to the database. This allows the database administrator to recover the database to the state at the time of the failure, even if the data file disk is damaged.

Configuring the Database archive log

The way to configure the database archive log consists of the following 3 steps:

Query how the database is archived and determine how it is not currently archived

Connect the target database with the SYS user as SYSDBA, and then execute the archivelog List command to view the database archive mode:

Close the database and start the database to Mount state

Use the ALTER DATABASE Archivelog command to set the database to archive mode and verify that the archive mode of the database has changed

Get archived log information

The data dictionary view helps you get database configuration information. Users get archived log information by using the V$archive_dest and V$archive_log views

V$archive_dest: Displays all current archive log storage locations and their status

V$archive_log: Displaying historical archive log information

How to view all valid archive log file storage directories

Gets the information of the archived log file, which copies the online redo log files to an archive log file after each log switchover, resulting in a sequential sequence of log files that can be used to restore a backup. The names and locations of these log files are controlled by a number of initialization parameters.

If you have any questions about this article, please add the following discussion

Oracle 11g R2 Management archive log files