归档夯住
本帖最后由 lllzd 于 2010-12-3 22:50 编辑我查看我的归档日志发现归档日志与现在的redo日志序列号连接不上
SQL> select recid,name from v$archived_log;
36 /opt/oracle/flash_recovery_area/ABC/archivelog/2010_12_02/o1_mf_1_37_6hgq19b2_.arc
RECID NAME
---------- --------------------------------------------------------------------------------
37 /opt/oracle/flash_recovery_area/ABC/archivelog/2010_12_02/o1_mf_1_38_6hgq3xpw_.arc
38 /opt/oracle/flash_recovery_area/ABC/archivelog/2010_12_02/o1_mf_1_39_6hgq719d_.arc
SQL> archive log list;
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination
USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 40
Next log sequence to archive 40
Current log sequence
42
少了39
然后我SQL> alter system switch logfile;数据库就一直夯着，请问如何解决，什么原因那？
磁盘没有满
闪回区2G，也没满，
没有归档到别处
怎么不看看日志呢？
页:
[1]