Yuan Yao, An Oracle ACE's Blog

One of my clients reported that some archive logs were not backed up by their backup job. We replicated this issue in a test environment, and here is the process of our experiment. First, we checked the v$archived_log view but couldn’t find the relevant records. We also used RMAN’s LIST…

I work as a database support engineer for a company with 20,000 clients, which means I encounter all kinds of unique issues. One of our clients faced a persistent problem where their database was generating a large number of trace files, frequently filling up the hard disk. Here’s how I…