Q The title is as follows ：
stay Oracle in , How to remove V$ARCHIVED_LOG Expired information in view ？
A The answer is as follows ：
In the use of RMAN command （DELETE ARCHIVELOG ALL;） After deleting the archive information V$ARCHIVED_LOG In the view NAME Column is empty , But you can still find the deleted archive information , This is because of the use of RMAN The command does not clear the contents of the control file when deleting the archive log , Lead to V$ARCHIVED_LOG The incomplete information left behind is out of date .
Use the following command to clear the control file about V$ARCHIVED_LOG Information about ：