有时候,你可能需要维护control file中的archivelog记录,比如,archivelog记录过多,会导致备份过程中【control file sequential read】的等待事件。比较简单的做法是手动清理v$archived_log。下面在我的环境中演示该过程。查看下备库当前的状态SQL> select name,database_role,open_mode from v$database;
NAME DATABASE_ROLE OPEN_MODE
--------- ---------------- --------------------
ENMY PHYSICAL STANDBY READ ONLY WITH APPLY
SQL>
SQL> set linesize 400
SQL> col name for a65
SQL> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log;
NAME
...
继续阅读
(16)