打開資料庫報錯

問題：打開資料庫時候提示log日志錯誤

SQL>startup

ORACLE instance started

total system global area 232323444bytes

fixed size         1212987 bytes

variable size   102839483 bytes

database buffers 171829283 bytes

redo buffers        715800 bytes

database mounted

ORA-16014:log 3 sequence# 241 not archived,no avalilable destinations

ORA-00312：online log 3 thread 1:'/home/app/oracle/oracle/oradata/test/redo03,log'

解決：

$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on 星期日 3月 4 04:26:46 2012

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

connected to target database: CRM (DBID=3556636747, not open)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=150 devtype=DISK

validation failed for archived log

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2011_06_13/o1_mf_1_228_6zczymlz_.arc recid=1 stamp=753686248

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2011_06_13/o1_mf_1_229_6zd1gj6n_.arc recid=2 stamp=753687776

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2011_10_19/o1_mf_1_230_79xkjjm4_.arc recid=3 stamp=764919847

validation succeeded for archived log

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_01_05/o1_mf_1_231_7jcc3znb_.arc recid=4 stamp=771746324

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_08/o1_mf_1_232_7m4t8pbk_.arc recid=5 stamp=774678171

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_13/o1_mf_1_233_7ml3dqs3_.arc recid=6 stamp=775113500

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_25/o1_mf_1_234_7nm9qylv_.arc recid=7 stamp=776201347

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_25/o1_mf_1_235_7nmogwh0_.arc recid=8 stamp=776213344

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_25/o1_mf_1_236_7nmojqdc_.arc recid=9 stamp=776213399

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_26/o1_mf_1_237_7nmvs3k6_.arc recid=10 stamp=776219816

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_26/o1_mf_1_238_7nmwxkgx_.arc recid=11 stamp=776220977

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_26/o1_mf_1_239_7nmwyn3q_.arc recid=12 stamp=776221012

archive log filename=/home/app/oracle/flash_recovery_area/CRM/archivelog/2012_02_26/o1_mf_1_240_7nmwzk2o_.arc recid=13 stamp=776221041

Crosschecked 13 objects

RMAN>delete expired archivelog all;

released channel: ORA_DISK_1

List of Archived Log Copies

Key     Thrd Seq     S Low Time   Name

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

1       1    228     X 17-5月 -11 /home/app/oracle/flash_recovery_area/CRM/archivelog/2011_06_13/o1_mf_1_228_6zczymlz_.arc

2       1    229     X 13-6月 -11 /home/app/oracle/flash_recovery_area/CRM/archivelog/2011_06_13/o1_mf_1_229_6zd1gj6n_.arc

3       1    230     X 13-6月 -11 /home/app/oracle/flash_recovery_area/CRM/archivelog/2011_10_19/o1_mf_1_230_79xkjjm4_.arc

Do you really want to delete the above objects (enter YES or NO)? YES

deleted archive log

Deleted 3 EXPIRED objects