OracleRedolog redo log

Source: Internet
Author: User
In Oracle databases, there is a log file called redo log file, which is commonly known as redolog. There are two types of redolog: Online redo log and archive log.

In Oracle databases, there is a log file called redo log file, which is commonly known as redolog. There are two types of redolog: Online redo log and archive log.

Redo log

In Oracle databases, there is a log file called redo log file, which is commonly known as redolog. There are two types of redolog: Online redo logs and archived logs.

ONLINE Redo log

Online redo log is mainly used for: the Oracle database server suddenly loses power, suddenly restarts, or executes shutdown abort and other commands so that after the server restarts, oracle Database cannot start the instance normally. At this point, online redo logs are useful. Oracle will use online redo logs to restore the database to the time before the server power loss, so that the database can be started normally. In Oracle databases, by default, there are at least two redo log groups, and each group contains at least one redo log file. The log group is not automatically added. After a full log is written, the next log is automatically written. After the next one is fully written, it will start from the first one.

Archive redo log

Archive logs are mainly used for hardware-level errors: the disk's Bad Sectors cause read and write failures, disk damage, and database data loss. Archive log files are used to restore the database to the time point where the archive log is located, and then restore the database to the current time point through online redo log files. Archive log files can be considered as backups of online redo log files. That is, when a redo log file is filled up, the archived log file will keep a copy of its backup. (As mentioned above, online redo log files will be automatically overwritten). Therefore, archiving log files are backups of old online log files.

Oracle 10g REDO log

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.