What does oracle archiving mean?

In Oracle, archiving is the process of converting online logs into archived logs. Oracle can save online log files to multiple different locations. When the log archive is opened, the log content can be saved before being overwritten. Store in archive directory.

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

What does oracle archiving mean

Oracle archiving is a piece of software in Oracle management. It is a log file that records any operations on the database. Archive logs

oracle uses circular logs In this way, when the log file is recycled, the log content is overwritten.

When log archiving is turned on, the log content can be stored in the archive directory before being overwritten.

With the backup strategy, the database can be restored to any point in time.

Oracle can save online log files to multiple different locations. The process of converting online logs into archive logs is called archiving.

The corresponding log is called an archive log.

The archive log is a copy of the online redo log group file. It contains redo records and a unique logsequence number. It archives a log file in the log group.

If one of the group damaged, another available log will be archived. For log switching in archive mode,

When the log archiving is completed, the next log can be overwritten or reused. If the automatic archiving function is turned on, the background The process arcn automatically completes archiving when the log is switched, otherwise manual archiving is required.

Use of archive log: restore database, update standby database, use LogMiner to extract relevant information of historical logs

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What does oracle archiving mean?. For more information, please follow other related articles on the PHP Chinese website!