Oracle 如何规范清理v$archived_log记录实例详解

SQL> select sequence#,applied from v$archived_log order by sequence# ;

 SEQUENCE# APPLIED
....................
 SEQUENCE# APPLIED
---------- ---------
   9376 NO
   9377 NO
   9377 NO
   9378 NO
   9378 NO
   9379 NO
   9379 NO
   9380 NO
   9380 NO
   9381 NO
   9381 NO

 SEQUENCE# APPLIED
---------- ---------
   9382 NO
   9382 NO

11200 rows selected.

SQL> 

SQL> archive log list;
Database log mode     Archive Mode
Automatic archival     Enabled
Archive destination    USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   164
Next log sequence to archive  166
Current log sequence      166
SQL> 

SQL> execute sys.dbms_backup_restore.resetCfileSection(11);

PL/SQL procedure suessfully pleted.

SQL> select sequence#,applied from v$archived_log order by sequence# ;

no rows selected

SQL> 

SQL> alter system switch logfile;

System altered.

SQL> select sequence#,applied from v$archived_log order by sequence# ;

 SEQUENCE# APPLIED
---------- ---------
    166 NO

SQL> execute sys.dbms_backup_restore.resetCfileSection(11);

PL/SQL procedure suessfully pleted.

SQL> select sequence#,applied from v$archived_log order by sequence# ;

no rows selected

SQL> 

#master库上v$archived_log表记录数
SQL> select count(1) from v$archived_log;

 COUNT(1)
----------
  623616

SQL> 

#standby库上v$archived_log表记录数
SQL> select count(1) from v$archived_log;

 COUNT(1)
----------
  2226823

SQL>