ORA-16038

问题：启动数据库报错ORA-16038

处理：

[oracle@oraclelinux ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 5 21:01:00 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  444596224 bytes

Fixed Size                  1219904 bytes

Variable Size             117441216 bytes

Database Buffers          322961408 bytes

Redo Buffers                2973696 bytes

Database mounted.

ORA-16038: log 4 sequence# 45 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 4 thread 1: '/u01/oradata/dbtest/redo04.log'

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     45

Next log sequence to archive   45

Current log sequence           48

SQL> select group#,sequence#,archived,status from v$log;

    GROUP#  SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1         46 NO  INACTIVE

         4         45 NO  INACTIVE

         3         48 NO  CURRENT

         2         47 NO  INACTIVE

SQL> alter database clear logfile group 4;

alter database clear logfile group 4

*

ERROR at line 1:

ORA-00350: log 4 of instance TESTENV01 (thread 1) needs to be archived

ORA-00312: online log 4 thread 1: '/u01/oradata/dbtest/redo04.log'

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> alter database open;

Database altered.

SQL> 

完了备份当前数据库

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-731997/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15720542/viewspace-731997/