Re: HELP! URGENT! Database down!

Make sure that you freed up space in the directory specified by the init<your sid here>.ora parameter log_archive_dest. If this is the case, (and I'm going out on a limb and assuming this is a UNIX box) cd to that directory and do a df -k . to see if that filesystem is showing up as 100% full or not (sometimes just deleting stuff from a directory in the system doesn't free up the space immediately if the system thinks that something still needs it--you can also verify this by trying to create/copy a file into that directory). In this case, I would generally let my sys admin intervene to try to make the system release that space (free up those inodes--could probably unmount the filesystem and then mount it back again, but I've never tested that myself). If worse comes to worse, set the log_archive_dest parameter in your init<your sid here>.ora file to a directory that you know has space available (you can actually create a file there yourself) and then startup the database. Hope this helps.

Jeff S

Pat Lavery, Sr. <pl_at_creditwatch-inc.com> wrote in message news:37853BF3.689654F9_at_creditwatch-inc.com...
> I have a database which I believe ran out of space on one of the drives
> to archive the redo logs. When this occured, the database shut down. I
> have since made room on the drive which had run out of space to store
> the redo log files but I still can't get the db back up and running. I
> can connect to the database as 'internal' but when I give the startup
> command, I get the following:
>
> ORACLE instance started.
> Database mounted.
> ORA-0255: error archiving log 1 of thread 1, sequence # 3079
> ORA-00312: online log 1 thread 1: '/disks/disk1/gte_files/redo1gte.dbf'
> ORA-00272: error writing archive log
> Attempting to dismount database .......Database dismounted.
> Attempting to shutdown instance.....ORACLE instance shut down.
>
>
> HELP! How can I get it up and running again? It is an Oracle 7.1
> database.
>
>
Received on Thu Jul 08 1999 - 21:10:40 CDT