Re: Hot backup ran out of space, now oracle won't open

Gregory Bloom wrote:
> A hot backup of 10g on Fedora Core 3 ran out of disk space and thus
> failed. I wouldn't think that'd be the end of the world, but it
> appears Oracle does. Now when I try to open the database, it says:
>
> ORA-16038: log 2 sequence# 15915 cannot be archived
> ORA-16050: destination exceeded specified quota size
> ORA-00312: online log 2 thread 1:
> '/archive1/app/oracle/product/10.2.0/oradata/orcl/redo02.log'
>
> and refuses to open. The odd thing is that this error appears to me to
> have been generated when the backup had failed, and not as part of the
> process of opening the database.
>
> Can anyone suggest a way to get over this problem and get the database
> back online again?

It appears as if you are running in ARCHIVELOG mode and you have filled up the space in your online logs. You probably don't have an empty one available for the system to switch to ( so it can start ) and you may be out of space where it is trying to copy one of the full online logs to an archived copy.

You can switch the database out of ARCHIVELOG mode temporarily ( if you wish ) and start it up. Lots of stuff you can find from google on how to do this ( plus http://asktom.oracle.com of course ).

Or maybe as someone else suggested have more space available to where oracle is trying to put it's copy of the online log.

Bottom line you need to monitor how much space is available periodically on your system so that you don't run out ( is my guess ). Received on Wed May 17 2006 - 17:24:55 CDT