Shulou(Shulou.com)05/31 Report--

The purpose of this article is to share with you about how Oracle can check whether archives are ready for library applications. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

First, query the v$archived_log view, and then analyze the applied field information. The official description is as follows:

Indicates whether an archived redo log file has been applied to thecorresponding physical standby database. The value is always NO for localdestinations.This column is meaningful on a physical standby database for rows whereREGISTRAR = RFS: ■ If REGISTRAR = RFS and APPLIED = NO, then the log file has beenreceived but has not yet been applied. ■ If REGISTRAR = RFS and APPLIED = IN-MEMORY, then the log file hasbeen applied in memory, but the datafiles have not yet been updated. ■ If REGISTRAR = RFS and APPLIED = YES, then the log file has beenapplied and the datafiles have been updated.This column can be used to identify log files that can be backed up anddeleted. When used for this purpose, the value IN-MEMORY should betreated as if it were NO. Thank you for reading! This is the end of the article on "how to check whether the archive is used in the library". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.