watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=

watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=



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 :

EXECUTE SYS.DBMS_BACKUP_RESTORE.RESETCFILESECTION(11);