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

"Gregory Bloom" <Gregory.Bloom_at_gmail.com> wrote in message news:1147898075.204084.210440_at_u72g2000cwu.googlegroups.com...
>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?
>

Nothing really to do with your backup, exactly, except that the same device you used for backup is the one your archive logs go to.

Direct them somewhere else
ALTER SYSTEM SET LOG_ARCHIVE_DEST_n somewhereelse; or else, delete some of those archivelogs that you backed up already, to make some room on that device.

Oracle will theh archive your online logs, and you`ll be able to logon again.

No need to shutdown your database. Just make room on your disk where archivelogs go.

Syltrem Received on Fri May 19 2006 - 12:24:49 CDT