What are the values of V $ logfile. Status and V $ log. Status?

Source: Internet
Author: User

1. V $ logfile. Status
Http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1152.htm#sthref3730)
Type: varchar2 (7)
Status of the log member:
1. Invalid-file is inaccessible (File inaccessible)
2. stale-file's contents are incomplete (indicating that the file content is incomplete, for example, adding a log file Member)
If the redo log file group member has never been used,
Either due to a new redo log file group or a retries red member,
The value of status is stale until the log file member is used
To record redo information.
3. Deleted-file is no longer used (this file is no longer in use)
4. null-file is in use (the file is in use)

1. V $ log. Status
Http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1150.htm#sthref3726)
Type: varchar2 (16)
Log status:

Unused-Online redo log has never been written to. This is the state of a redo
Log that was just added, or just after a resetlogs, when it is not
Current redo log.
(It indicates that no logs are written to the redo log group on the machine. log files in this status are newly added,
Or the status after the resetlogs operation when the log is not the current redo log)
Current-current redo log. This implies that the redo log is active. The redo log
Cocould be open or closed.
(The current online redo log group, which means the online redo log group is active)
Active-log is active but is not the current log. It is needed for crash recovery. It
May be in use for block recovery. It may or may not be archived.
(The online redo log group is active, but not the current online redo log group. This status is required for crash recovery.
The log, which may be used for block recovery. It may have been archived or not archived)

Clearing-log is being re-created as an empty log after an alter Database
Clear logfile statement. After the log is cleared, the status changes
To unused.
(This indicates that the log is being rebuilt to
Empty log. The status of the log is changed to unused after it is cleared .)

Clearing_current-current log is being cleared of a closed thread. The log can
Stay in this status if there is some failure in the switch such
As an I/O Error writing the new log header.
(Indicates that the thread in the current log file is being cleared. If some fault occurs during switchover,
If an I/O error occurs when a new log title is written, the log can stay in this status .)

Inactive-log is no longer needed for instance recovery. It may be in use
Media recovery. It might or might not be archived.
(This indicates that online redo log groups are no longer required for routine recovery. It may have been archived or not archived .)

 

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.