不能正常归档引起数据库挂起的解决方法

文章作者 100test 发表时间 2007:10:15 12:56:16
来源 100Test.Com百考试题网

在0drop table操作时，database 挂起，不能0drop table。查alert_sid.log，找到有用信息。
信息如下：
Sat Sep 15 21:04:58 2007
Thread 1 advanced to log sequence 18
Current log# 2 seq# 18 mem# 0: /u01/app/oracle/oradata/dg1/redo02.log
Mon Sep 17 03:05:06 2007
Thread 1 advanced to log sequence 19
Current log# 3 seq# 19 mem# 0: /u01/app/oracle/oradata/dg1/redo03.log
Tue Sep 18 00:57:46 2007
ORACLE Instance dg1 - Can not allocate log, archival required
Tue Sep 18 00:57:46 2007
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 20
All online logs needed archiving
Current log# 3 seq# 19 mem# 0: /u01/app/oracle/oradata/dg1/redo03.log
不能正确归档！！！

sys@DG1> archive log list
Database log mode Archive Mode
Automatic archival Disable
Archive destination /u01/app/oracle/product/9.2.0/dbs/arch
Oldest online log sequence 18
Next log sequence to archive 20
Current log sequence 20
[oracle@dg1 dbs]$ ls
initdg1.ora initdw.ora init.ora lkDG1 lkOEMREP orapwdg1 orapwOEMREP spfiledg1.ora spfileOEMREP.ora
[oracle@dg1 dbs]$ pwd
/u01/app/oracle/product/9.2.0/dbs
竟然没有归档路径的arch文件夹
[oracle@dg1 dbs]$ mkdir arch(建一个arch文件夹)
sys@DG1> alter system archive log start.(让系统归档)
System altered.
查看alert_sid.log
Archiving is enabled
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
ARC0: Archival started
Tue Sep 18 08:45:48 2007
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=14
ARC1: Archival started
ARC1: Evaluating archive log 1 thread 1 sequence 17
Tue Sep 18 08:45:48 2007
ARC0: Evaluating archive log 1 thread 1 sequence 17
ARC0: Unable to archive log 1 thread 1 sequence 17
Log actively being archived by another process
ARC0: Evaluating archive log 2 thread 1 sequence 18