Current/active/inactive/unused status of Oracle log files

Source: Internet
Author: User
Inactive: indicates an inactive log. This log is no longer required for instance recovery, but may be used for media recovery. Inactive logs may not be archived. If the number

Inactive: indicates an inactive log. This log is no longer required for instance recovery, but may be used for media recovery. Inactive logs may not be archived. If the number

You can view the log file status in the v $ log view.

The following statuses are available: current/active/inactive/unused

Current: The current log file, which is active and currently in use. The current log file is required for crash recovery.

Active: the non-current log of the activity. The log may have been archived or not archived. The active log file will be used for crash recovery.

Inactive: indicates an inactive log. This log is no longer required when the instance is restored, but may be used when the media is restored. Inactive logs may not be archived. If the database is in archive mode, Log files cannot be overwritten before Archiving is completed, and the active process will be waiting in Log File Switch (Archiving Needed.

Unused: Logs have never been written. Such Logs may have been added to the database or Reset after the Reset Logs. This status is changed after being used.

Oracle log mining

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.