Database Backup and Recovery (MOSC)

MOSC Banner

Filesystem 100% full on which dbf files reside. Cannot restart database

edited Jul 9, 2013 9:20PM in Database Backup and Recovery (MOSC) 13 commentsAnswered ✓
Initially this morning doing sqldeveloper query when I received message:

ORA-01114: IO error writing block to file  (block # )
ORA-01114: IO error writing block to file 201 (block # 469888)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 469888
Additional information: -1
01114. 00000 -  "IO error writing block to file %s (block # %s)"
*Cause:    The device on which the file resides is probably offline. If the
           file is a temporary file, then it is also possible that the device
           has run out of space. This could happen because disk space of
           temporary files is not necessarily allocated at file creation time.

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