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> execute sys.dbms_backup_restore.resetCfileSection(11);
PL/SQL procedure successfully completed.
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 successfully completed.
SQL> select sequence#,applied from v$archived_log order by sequence# ;
no rows selected
SQL>