Home » RDBMS Server » Server Administration » Archival Error (Database:Oracle 11g (11.2.0.2.0 ) OS: AIX 6)
Archival Error [message #536934] Sat, 24 December 2011 02:43 Go to next message
dbcop
Messages: 37
Registered: September 2006
Location: india
Member
Environment: Database:Oracle 11g (11.2.0.2.0 ) OS: AIX 6
Hi Gurus,

Kindly help me solving the following error.

I am getting the following error continuosly in the alert_sid.log and it is also causing a Database shutdown frequently and also to bring it up I need to put in Noarchivelog and then startup works . Currently after bringing up the database in no archive log mode again I restarted it in archive log mode . The following are the errors in alert file.

Sat Dec 24 08:10:48 2011
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance JD1 - Archival Error
ORA-16014: log 3 sequence# 51 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/oracle/JD1/origlogA/log_g13m1.dbf'
ORA-00312: online log 3 thread 1: '/oracle/JD1/mirrlogA/log_g13m2.dbf'
Sat Dec 24 08:15:48 2011
ARC0: All Archive destinations made inactive due to error 333
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/JD1/oraarch/JD1arch1_51_769449077.dbf' (error 333) (JD1)
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance JD1 - Archival Error
ORA-16038: log 3 sequence# 51 cannot be archived
ORA-00333: redo log read error block count
ORA-00312: online log 3 thread 1: '/oracle/JD1/origlogA/log_g13m1.dbf'
ORA-00312: online log 3 thread 1: '/oracle/JD1/mirrlogA/log_g13m2.dbf'
Sat Dec 24 08:16:48 2011


Corresponding trace file contains the following

ARC3: All Archive destinations made inactive due to error 333
*** 2011-12-24 02:40:46.124 2864 krsi.c
krsi_dst_fail: dest:1 err:333 force:0 blast:1
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
DDE: Problem Key 'ORA 312' was flood controlled (0x5) (no incident)
ORA-00312: online log 3 thread 1: '/oracle/JD1/origlogA/log_g13m1.dbf'
ORA-00312: online log 3 thread 1: '/oracle/JD1/mirrlogA/log_g13m2.dbf'
*** 2011-12-24 02:40:46.139 4415 kcrr.c

V$archive_dest_status reveals the following

DEST_NAME STATUS ERROR
-------------------------------------------------- ------------------------------ ------------------------------------------------------------
LOG_ARCHIVE_DEST_1 ERROR ORA-00333: redo log read error block count


Thanks for any help.
Regards
Dbcop

[Updated on: Sat, 24 December 2011 02:59]

Report message to a moderator

Re: Archival Error [message #537054 is a reply to message #536934] Mon, 26 December 2011 06:41 Go to previous messageGo to next message
rizwankhalid214
Messages: 1
Registered: December 2011
Location: Lahore, Pakistan
Junior Member

An error occurred while reading the redo log file. i think the mount point/directory permissions are changed mistakenly. check /oracle/JD1/origlogA/ permission setting on OS level.

regards,
Re: Archival Error [message #537273 is a reply to message #536934] Tue, 27 December 2011 08:17 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member

[phobos] /opt/app/oracle/product/10.2.0gas> oerr ora 333
00333, 00000, "redo log read error block %s count %s"
// *Cause:  An IO error occurred while reading the log described in the
//          accompanying error.
// *Action: Restore accessibility to file, or get another copy of the file.
[phobos] /opt/app/oracle/product/10.2.0gas>

Previous Topic: ORA-04030 : Out of Process Memory
Next Topic: Split 30GB DBF File into 6 - 5GB Files
Goto Forum:
  


Current Time: Thu Mar 28 15:43:28 CDT 2024