What happens when the archive log directory becomes full in Oracle Database 10g?

Answer

rtrembley
Vote Up (21)

After the directory becomes full, the next time database tries to write an archive log it will suspend database activity, and will stay suspended until there is enough space available for a new file.  If you are looking for a decent beginners guide to Database, there is a book that Oracle Press puts out called, creatively, Oracle Database 10g, A Beginners Guide.  You might find it useful.  

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question
randomness