Database Administration (MOSC)

MOSC Banner

Archivel process hungs and kill the sessions.

edited Jan 4, 2012 5:53PM in Database Administration (MOSC) 2 commentsAnswered
hi experts,
In our three node RAC database.  Archival hangs while creating arch file for seq#2227.
 There are two arch logs generated for seq#2227
 
  % l /isdprod/isddrop_fra/ISDDROP/archivelog/2011_12_30/o1_mf_1_2227_*
  -rw-rw---- 1 arudba arudba 46805504 Dec 30 18:12
  /isdprod/isddrop_fra/ISDDROP/archivelog/2011_12_30/o1_mf_1_2227_7hwvvmkl_.arc
  -rw-rw---- 1 arudba arudba 46805504 Dec 30 18:18
/isdprod/isddrop_fra/ISDDROP/archivelog/2011_12_30/o1_mf_1_2227_7hww72oy_.arc
 
 
  1. Error reported in alert @ Fri Dec 30 18:12:16 PST 2011
 
  ORA-19504: failed to create file
  "/isdprod/isddrop_fra/ISDDROP/archivelog/2011_12_30/o1_mf_1_2227_%u_.arc"
  ORA-27086: unable to lock file - already in use
  Linux-x86_64 Error: 4: Interrupted system call
 
  At that time there was arch file created on OS with timestamps Dec 30 18:12

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center