Redo log does not expire in v$archived_log
Hi All,
I have a database that shows 10 redo log files with a status of Active in v$archived_log. I am looking for a way to force those to expire.
Background:
The development database was refreshed from the production database, then upgraded from Oracle 11.2.0.4 to 12.1.0.2. This is a standalone database.
One check we run is to see if there are archive logs that have not been backed up in the last day.
select NAME,deleted,completion_time,status
from v$archived_log where deleted != 'YES' and completion_time < sysdate - 1 and status != 'X' ;
Archive log backups are running as expected. The above query returns old redo log files that are no longer needed, and do not exist on the server.
0