How to recover from an Oracle DB archivelog full error

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

How to recover from an Oracle DB if the disk/file system for archive logs gets full

Note: if DB is hung at shutdown i.e. shu immediate, then force a shutdown, like below

Get size used for if needed

Remove Archive logs with rm in ASMCMD

Open the DB for usage

Change archivelog max size

To delete all all archivelog’s

To disable archivelog mode

Leave a Reply

Notify of