Re: HELP! URGENT! Database down!--Ammended statement

I chatted with my UNIX sysad and she said that the unmount & mount would probably work, but it would be easier to just use the 'sync' command to accomplish this.

Jeff S

WolfAlpha <wolfalpha_spamguard_at_home.com> wrote in message news:ASch3.13247$5i7.7965_at_news.rdc1.va.home.com...
> 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 Fri Jul 09 1999 - 23:36:22 CEST