Database Administration (MOSC)

MOSC Banner

DB hung as archive was filled up

edited Oct 6, 2015 6:28AM in Database Administration (MOSC) 3 commentsAnswered

I am back to basic but very curious to know how db version 9.2 bahved.

I was trying to shut AN instance

shutdown immediate and it just hung. There were no users and no tranactions.

After waiting for about 7 mints, I opened new session and I executed kill -9 PMON

First session ended. I started the instance and got error like

ORA-16038: log 1 sequence# 100 cannot be archived

ORA-19502: write error on file "", blockno (blocksize=)

ORA-00312: online log 1 thread 1: '/xxx/u50/oralog/redo01a.rdo'

ORA-00312: online log 1 thread 1: '/xxx/u51/oralog/redo01b.rdo'

I saw this and knew it was space. So I cleared archive space and I could startup and shutdown normally.

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