Open Database error

• 
  

Problem: Prompt log log error when opening database

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 '

Solve:

$ Rman Target/

Recovery manager:release 10.2.0.1.0-production on Sunday March 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
Validation failed for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2011_06_13/o1_mf_1_229_6zd1gj6n_.arc recid=2 stamp=753687776
Validation failed for archived log
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
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_08/o1_mf_1_232_7m4t8pbk_.arc Recid=5 stamp=774678171
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_13/o1_mf_1_233_7ml3dqs3_.arc Recid=6 stamp=775113500
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_25/o1_mf_1_234_7nm9qylv_.arc Recid=7 stamp=776201347
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_25/o1_mf_1_235_7nmogwh0_.arc Recid=8 stamp=776213344
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_25/o1_mf_1_236_7nmojqdc_.arc Recid=9 stamp=776213399
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_26/o1_mf_1_237_7nmvs3k6_.arc recid=10 stamp=776219816
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_26/o1_mf_1_238_7nmwxkgx_.arc Recid=11 stamp=776220977
Validation succeeded for archived log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2012_02_26/o1_mf_1_239_7nmwyn3q_.arc Recid=12 stamp=776221012
Validation succeeded for archived log
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 objects

Rman>delete expired Archivelog All;

Released Channel:ora_disk_1
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=150 Devtype=disk

list of archived Log Copies
Key      thrd seq     S low time   Name
---------------------------------
1       1    228     X 1 July-May -11/home/app/ Oracle/flash_recovery_area/crm/archivelog/2011_06_13/o1_mf_1_228_6zczymlz_.arc
2        1    229     X 1 March-June -11/home/app/oracle/flash_recovery_area/crm/ Archivelog/2011_06_13/o1_mf_1_229_6zd1gj6n_.arc
3       1    230      X 1 March-June -11/home/app/oracle/flash_recovery_area/crm/archivelog/2011_10_19/o1_mf_1_230_ 79xkjjm4_.arc

Really want to delete the above objects (enter YES or NO)? YES
Deleted archive 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
Deleted archive Log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2011_06_13/o1_mf_1_229_6zd1gj6n_.arc recid=2 stamp=753687776
Deleted archive Log
Archive Log Filename=/home/app/oracle/flash_recovery_area/crm/archivelog/2011_10_19/o1_mf_1_230_79xkjjm4_.arc Recid=3 stamp=764919847
Deleted 3 EXPIRED objects

rman> ALTER DATABASE open;

Database opened

Open Database error